Assign Macro to Toolbar Problem

N

Neill Wood

I currently have a large spreadsheet that contains a
series of macros used for navigation.
I have assigned these macros to a menu and toolbar which
works fine.

The problem occurs when I save the file I am using as a
new name ie file_june.xls to file July.xls
The macros on the toolbar/Menu all still refer to the June
file rather than the July file.
Does anyone know a way of assigning only the macro name
and not preceded by the filename.

Thank you for any help
 
Top