Dynamic Worksheet Names
Mike .....
Worked like a charm ! I'm a novice at code writing to say the least. Thank
you so much not only for the help, but for such a prompt reply.
Regards ...
--
HOOS77
"HOOS77" wrote:
I inserted the following code for each worksheet tab to dynamically change
the sheet name to match the value in the designated target cell in that
worksheet:
Private Sub Worksheet_Activate()
ActiveSheet.Name = Range("C7").Value
End Sub
It works OK with one quirk that I don't know how to fix.
When I change the value in the target worksheet cell (C7), the worksheet tab
name does not change until I click on another worksheet tab, then click back
on the worksheet tab I just changed.
How do I make the tab name change as soon as the target cell is updated ?
Thanks !!!
--
HOOS77
|