Tab Naming

J

Johnny

I have the code below to rename a tab based on a cell contents in that
worksheet. They only way to get the tab to rename is to change the cell
contents. That's fine but the cell is referencing another worksheet and when
I change that cell, the tab I need changed does not rename.
 
B

Bernard Liengme

Are you talking about renaming a SHEET - the TAB is just the thing you use
to open a Sheet
Can we see the code and the formula?
best wishes
 
Top