Assign Macros to Toolbar Problem

[Neill Wood]

I have a large spreadsheet that I have added a toolbar and
menu to with macros for navigation.
The problem occurs when I change the name of the
spreadsheet I am using from workjune.xls to workjuly.xls.
All of the macros on the toolbar and menu still refer to
the macros in the old file not the new one.
Is there any way of assign the macros without the filename
so that it always looks for the macro in the current file.

Any ideas would be greatly appreciated.

 

[Mark Graesser]

Neil,
If you have the file open in Excel and use Save As to change the name it
should update the tollbar links to the new name. If you change the file
name outside of Excel then it doesn't effect the toolbar.

Good Luck,
Mark Graesser