Sean,

If you put it in the correct place, then just change the value of G1 (even
to what it already contains, just force the change event), and you will see
the tab name change.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"S_Steele1812" wrote in message
...
Bob,
Is there something that I have to do to execute this code. I
printed
it into the sheets module and nothing happened. I confess to being a total
NooB at this. I have written macros before but that is about it.

Thanks
Sean Steele

"Bob Phillips" wrote:

Private Sub Worksheet_Change(ByVal Target As Range)

On Error GoTo ws_exit:
Application.EnableEvents = False
If Target.Address = "$G$1" Then
Me.Name = Target.Value
End If

ws_exit:
Application.EnableEvents = True
End Sub

'This is worksheet event code, which means that it needs to be
'placed in the appropriate worksheet code module, not a standard
'code module. To do this, right-click on the sheet tab, select
'the View Code option from the menu, and paste the code in.


--

HTH

RP
(remove nothere from the email address if mailing direct)


"S_Steele1812" wrote in message
...
Is there a way to make a tab assume the same value as a cell on that
sheet?
ie. value of cell G1 is Feeler have tab value be Feeler and have the
tab
value update automaticaly when the Cell value is changed.