renaming workbook, HOWTO update references?

[Lexje]

Hi everybody!

I have a workbook containing a lot of names, the workbook has some 30 odd sheets.
How can we change the names related to the name of the workbook, so that we can rename the workbook and keep everything running?

Is it possible to do this via code?

Thanks!

Erwin

 

[dsgs]

there is a add-in (find link), but i don't have it here, i found it somewhere on the net maybe somebody knows where to find it....

 

[ken2step]

Are you talking about named ranges? If so, if you do a 'save as' and rename the workbook you should be just fine.