Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
worksheet change?
I have the following brief macro to change the tab name based on a change to
cell "G1": Private Sub Worksheet_SelectionChange(ByVal Target As Excel.Range) ActiveSheet.Name = ActiveSheet.Range("G1") End Sub How do I change the tab name on a total of 12 worksheets (different names) when I make a change on the 13th worksheet? The 12 worksheets all are linked to the 13 worksheet so that when I change the 13th sheet, the others are updated and I would like to update (change) the tab names when the the sheets are updated. I've thought about placing the above macro in each worksheet but I can't even get the one to update (name change) when I modify the 13th sheet. Any guidance would be greatly appreciated. Jack |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how to change the pivot chart automaticaly as values in the worksheet change | Excel Worksheet Functions | |||
change formula in a shared worksheet without losing change history | Excel Worksheet Functions | |||
Change in one Worksheet Activates Another Worksheet Change | Excel Programming | |||
Cell value change to trigger macro (worksheet change event?) | Excel Programming | |||
Change Cell from Validated List Not Firing Worksheet Change Event | Excel Programming |