Programatically Rename Tabs

[Karl Burrows]

I have several linked workbooks (2000, XP, 2003) where the main workbook
tabs may be renamed as projects are archived and new ones are added. The
problem I have is to update the links for any tabs that are renamed, I have
to have all the workbooks open so each sees the changes live.

Is there a way to setup a named cell in the main workbook that creates the
tab name so that as I change tab names, it links to the new workbook and
updates the links to the new tab as well as renaming the tabs in the other
workbooks?

Is there a better way to approach this? We have about 7 workbooks that are
all linked to this main workbook and it would be nice to figure out a way to
automate this process.

Thanks!

 

[Tom Ogilvy]

You can write a macro to open all the workbooks and make the change. Then
close the ones you don't need. This might be the safest way.