"~Jeff~" wrote in message
...
Is there a way to set the spreadsheet up so that ...
Yes, with event code (if you mean "so that the sheet name becomes whatever's
in A4" & not the other way around).
Rightclick the sheet tab, click "View Code" ; then paste the following into
the worksheet module.
Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Address < "$A$4" Then Exit Sub
On Error GoTo 100:
ActiveSheet.Name = Target
Exit Sub
100:
MsgBox "Cannot rename sheet."
End Sub
|