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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top