Excel 2003 with SP2 on Win XP Home
I have an .xls file with macros run by custom toolbar buttons.
I had to move the file to another location on my hard drive and so the
reference path saved when I originally assigned the macro is no longer valid.
When I click a custom toolbar button I get a message that the macro (in the
old location) cannot be found.
If I call up the toolbar customise dialog box / assign macro, the "macro
name" window shows the file's old location. I can change this to the new one
and then save the file. The custom buttons then work OK.
But if I close the file then reopen it, the buttons no longer work, and I'm
back to square one.
I don't want to move the file back to its original location.
Any suggestions for a solution would be welcome

--
donwb