Don,
Thanks much for your quick response.
I must have missed something. After typing SAVE in Book 1 - Sheet1 (Code),
I clidked the X in the top right to close.
I then changed the value of cell a1 from "xxx" to "zzz" and the TAB remained
"Sheet1".
azbob
"Don Guillett" wrote:
right click sheet tabview codeinsert thisSAVE
When you change cell a1 the sheet name will change.
Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Address < "$A$1" Then Exit Sub
ActiveSheet.Name = Target
End Sub
--
Don Guillett
SalesAid Software
"azbob" wrote in message
...
How can I give a variable name to a worksheet tab based on a cell in the
worksheet?