I have a workbook that I copied and I need to change the tab name.

D

Dawnel

I have a workbook that I copied and I need to change the tab names
without screwing up the formulas and links, but updating with the new tab
names.

How can I do this?
 
M

Myrna Larson

Formulas that include sheet names will be fixed automatically by Excel when
you rename a sheet. The same is not true of any VBA code. That will have to be
modified manually.
 
Top