Custom toolbar issues

pilot · Apr 17th, 2002, 08:43 AM

Assume macro code is saved in "This Workbook" of old.xls and assigned to a button on "MyToolbar" which is attached to old.xls. I now want to give a copy of this file to someone so I open it, then SaveAs new.xls. At this point new.xls contains (a copy of) the code in "This Workbook". If I attach MyToolbar to new.xls, the macro from the toolbar button still references old.xls.

How can I truly create a copy of the file, complete with all code from "This Workbook" and all sheets, including its own attached copy of MyToolbar with button referencing macro code in the new file?

pilot · Apr 18th, 2002, 10:39 AM

Stirring the pot in hopes this rises to the top and someone has the answer.

klb · Apr 18th, 2002, 02:10 PM

Have you tried attaching the code to command buttons in the workbook instead of to a toolbar?

This worked for me when I emailed multiple copies of one spreadsheeet to about 50 people at different locations around the country.

pilot · Apr 18th, 2002, 02:19 PM

No, I haven't tried that. Do command buttons stay on top regardless of which sheet is selected?

Also, can someone give a 5 cent explanatioon of when you want code in "This Workbook" vs. when it would be better in a module attached to the workbook?

pilot · Apr 29th, 2002, 12:58 PM

Trying this again. How can command buttons be made to stay on top regardless of which worksheet is selected or visible? Is there a way to dock a group of command buttons similar to a toolbar? What I really want is the functionality of a custom toolbar but one that can be shared with others, with each file copy's custom toolbar buttons referring to macro code in its own file rather than pointing back to the original file.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Apr 17th, 2002, 08:43 AM	#1
pilot Board Regular Join Date: Feb 2002 Location: Houston, TX Posts: 303	Assume macro code is saved in "This Workbook" of old.xls and assigned to a button on "MyToolbar" which is attached to old.xls. I now want to give a copy of this file to someone so I open it, then SaveAs new.xls. At this point new.xls contains (a copy of) the code in "This Workbook". If I attach MyToolbar to new.xls, the macro from the toolbar button still references old.xls. How can I truly create a copy of the file, complete with all code from "This Workbook" and all sheets, including its own attached copy of MyToolbar with button referencing macro code in the new file?

Apr 18th, 2002, 10:39 AM	#2
pilot Board Regular Join Date: Feb 2002 Location: Houston, TX Posts: 303	Stirring the pot in hopes this rises to the top and someone has the answer.

Apr 18th, 2002, 02:10 PM	#3
klb Board Regular Join Date: Apr 2002 Location: Minnesota Posts: 821	Have you tried attaching the code to command buttons in the workbook instead of to a toolbar? This worked for me when I emailed multiple copies of one spreadsheeet to about 50 people at different locations around the country.

Apr 18th, 2002, 02:19 PM	#4
pilot Board Regular Join Date: Feb 2002 Location: Houston, TX Posts: 303	No, I haven't tried that. Do command buttons stay on top regardless of which sheet is selected? Also, can someone give a 5 cent explanatioon of when you want code in "This Workbook" vs. when it would be better in a module attached to the workbook?

Apr 29th, 2002, 12:58 PM	#5
pilot Board Regular Join Date: Feb 2002 Location: Houston, TX Posts: 303	Trying this again. How can command buttons be made to stay on top regardless of which worksheet is selected or visible? Is there a way to dock a group of command buttons similar to a toolbar? What I really want is the functionality of a custom toolbar but one that can be shared with others, with each file copy's custom toolbar buttons referring to macro code in its own file rather than pointing back to the original file.