Name spreadsheet as per contents of a cell

October 6, 2010 at 11:04:06
Specs: Windows XP
Is there anyway in Excell 2003 that I can name a certain spreadsheet as per the contents of a particular cell. For example Spreadsheet should be named the same as A! (contents being Project Ohio) so automatically that spreadsheet is called that or whatever is filled in in that cell.

Not sure that makes sense.


See More: Name spreadsheet as per contents of a cell

Report •

#1
October 6, 2010 at 11:24:37
It could be done with a Worksheet_Change macro:

Private Sub Worksheet_Change(ByVal Target As Range)
 If Target.Address = "$A$1" Then Me.Name = Target.Value
End Sub


Report •
Related Solutions


Ask Question