Hi
you have to use VBA for this. e.g. put the following code in your workshete
module
Private Sub Worksheet_Change(ByVal Target As Range)
if target.address="$A$4" then
on error resume next
application.enableevents=false
me.name=target.value
application.enableevents=true
end if
End Sub
--
Regards
Frank Kabel
Frankfurt, Germany
~Jeff~ wrote:
Is there a way to set the spreadsheet up so that the value in cell A4
appears as the sheet tab name?
|