Macros are VBA or visual base files. If you were to edit such, a find and replace could fix it in one pass. Best of luck.
Bob
My PC at work has just been upgraded from windowsNT to XP Pro, and Excel 97 to Excel 2002.
I had a lot of custom buttons, with macros attached, in my copy of Excel 97.
The two files that seem to store this were a file called personal.xls, in c:\program files\microsoft office\office\xlstart, and a file called robert8.xlb, stored in the WinNT folder on drive C.
I made copies of these files before I got my new PC
On the new version of excel, personal.xls is stored in a different path, c:\program files\microsoft office\office10\xlstart.
The problem I have is that all my custom buttons try to link to the personal.xls file via the old path, and I can't open 2 copies of this file at once.
I manually re-assigned all the buttons to macros at the new location, when I close and re-open excel, it has reverted back.
I opened personal.xls from the old path, did file/save as/ to the new path, all worked till I closed and opened excel, when every thing was as before.
How can I sort this, as it is driving me crazy?
Robert

Chowhound
Comic Vine
GameFAQs
GameSpot
Giant Bomb
TechRepublic