Thread
:
Variable worksheet name (tab) linked to cell in same worksheet
View Single Post
#
4
Posted to microsoft.public.excel.worksheet.functions
Don Guillett
external usenet poster
Posts: 10,124
Variable worksheet name (tab) linked to cell in same worksheet
I meant to copy/paste the macro into the worksheet module and then SAVE the
WORKBOOK.
--
Don Guillett
SalesAid Software
"azbob" wrote in message
...
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?
Reply With Quote
Don Guillett
View Public Profile
Find all posts by Don Guillett