Learner123
New Member
- Joined
- Sep 3, 2010
- Messages
- 11
I am having a probelm with macros assigned to a custom toolbar. I am using excel 2003.
1. I have created several macros in a workbook named "PLAN"
2. I then created a custom toolbar.
3. Through the customize dialog box, I assign the Macros to the custom tool bar button.
Everything work fine UNTIL...
If I do a SAVE AS for the workbook "PLAN" and call it something else like "PLAN2" and then close "PLAN2" and reopen "PLAN" the name of the macro assigned to the custom button has change
Where as before it was simply "PLAN"
now it is C:\Mydocuments\Test2.xls'!PLAN.
Since I have the workbook "PLAN" open and "PLAN2" is closed, excel now wants to open up "PLAN2" to access the macro assigned to that button.
I am creating a custom toolbar that will go with an excel workbook that I use as a template and will often resave it with different names.
I would like excel not to go looking in other workbooks for these macros since copies of the macros exist in the module attached to the workbook.
Every time I do a Save As the assigned macro gets renamed. I am not interested in making changes to Personal.xls, as other individuals will be using the workbook...
Does anyone have any ideas?
1. I have created several macros in a workbook named "PLAN"
2. I then created a custom toolbar.
3. Through the customize dialog box, I assign the Macros to the custom tool bar button.
Everything work fine UNTIL...
If I do a SAVE AS for the workbook "PLAN" and call it something else like "PLAN2" and then close "PLAN2" and reopen "PLAN" the name of the macro assigned to the custom button has change
Where as before it was simply "PLAN"
now it is C:\Mydocuments\Test2.xls'!PLAN.
Since I have the workbook "PLAN" open and "PLAN2" is closed, excel now wants to open up "PLAN2" to access the macro assigned to that button.
I am creating a custom toolbar that will go with an excel workbook that I use as a template and will often resave it with different names.
I would like excel not to go looking in other workbooks for these macros since copies of the macros exist in the module attached to the workbook.
Every time I do a Save As the assigned macro gets renamed. I am not interested in making changes to Personal.xls, as other individuals will be using the workbook...
Does anyone have any ideas?