Problem with macro assigned to custom toolbar button

[spydergt1]

Problem with macro assigned to custom toolbar button

I am having a probelm with macros assigned to a custom button on
custom button. I am using excel 2000.

1. I have created a macro called "Jump" in a workbook named "Test1"

2. I then created a custom toolbar and added a custom toolbar button t
that toolbar.

3. Through the customize dialog box I assign the Macro "Jump" to th
custom button.

Everything works fine UNTIL.

If I do a SAVE AS for the workbook "Test1" and call it something els
like "Test2" and then close "Test2" and reopen "Test1" the name of th
macro assigned to the custom button has change

Where as before it was simply "Jump"
now it is C:\Mydocuments\Test2.xls'!Jump.
Since I have the workbook "Test1" open and "Test2" is closed excel no
wants to open up "Test2" to access the macro assigned to that button.

I am creating a custom toolbar that will go with a excel sheet that
use as a template and will often resave it with different names.

I would like excel not to go looking in other workbooks for thes
macros since copies of the macros exist in the module attched to th
workbook

Every time I do a Save As the assigned macro gets renamed

Does anyone have any ideas

Spydergt

 

[Guest]

Try saving your macro in the personal macro workbook - a hidden spreadsheet that holds macros to be used in any spreadsheet that you open.