Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Toolbars change assigned macros

Status
Not open for further replies.

jigejo

Programmer
Jan 12, 2002
4
CA
I created a toolbar with several icons and assigned macros to each. I created a template file and the macros are associated with this template. When I edit the template and then save it to another (*.xls) file the assigned macros change to the new saved (*.xls) file. When I open up the template and activate the icons, they open up the (*.xls) sheet and try to run the macros in the new (*.xls) sheet. How can I prevent the macros from being reassigned everytime I save the new (*.xls) file
 
Hi,
Would it work to assign the toolbar buttons to macros in your Personal.xls? Skip,
metzgsk@voughtaircraft.com
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top