Custom buttons running a macro

rdeters · May 15th, 2002, 02:07 PM

I have created two custom buttons that run two different macros, that are only specific to one file. However, when someone else goes into the excel file, the buttons do not come with it. They would have to create these custom buttons themselves and configure them for each specific macro. Is there a way that when the excel file is opened, that the buttons automatically are available?

Anne Troy · May 15th, 2002, 02:17 PM

You need to build your toolbar within VBA.

http://www.cpearson.com/excel/menus.htm#vba

You can also try Tools-Customize, Toolbars and choose Attach to file, but I'm not sure if that works like that.

_________________
TheWordExpert

[ This Message was edited by: Dreamboat on 2002-05-15 13:18 ]

rdeters · May 15th, 2002, 02:22 PM

Thanks, Dreamboat, I'll try it out!

mikeyboy · May 15th, 2002, 02:57 PM

You can draw buttons right on the sheet. View - Toolbar - Drawing. Now go to the bottom and click on autoshape. Click on any shape (shape is now in memory) and click anywhere on the sheet itself and the button is now there! Format it as you like by right click on the button to get the menu and assign the appropriate macro to it.

[ This Message was edited by: mikeyboy on 2002-05-15 13:58 ]

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

May 15th, 2002, 02:07 PM	#1
rdeters New Member Join Date: May 2002 Location: Calgary, Canada Posts: 40	I have created two custom buttons that run two different macros, that are only specific to one file. However, when someone else goes into the excel file, the buttons do not come with it. They would have to create these custom buttons themselves and configure them for each specific macro. Is there a way that when the excel file is opened, that the buttons automatically are available?

May 15th, 2002, 02:17 PM	#2
Anne Troy MrExcel MVP Join Date: Feb 2002 Location: Allentown, PA Posts: 2,510	You need to build your toolbar within VBA. http://www.cpearson.com/excel/menus.htm#vba You can also try Tools-Customize, Toolbars and choose Attach to file, but I'm not sure if that works like that. _________________ TheWordExpert [ This Message was edited by: Dreamboat on 2002-05-15 13:18 ]

May 15th, 2002, 02:22 PM	#3
rdeters New Member Join Date: May 2002 Location: Calgary, Canada Posts: 40	Thanks, Dreamboat, I'll try it out!

May 15th, 2002, 02:57 PM	#4
mikeyboy Board Regular Join Date: Apr 2002 Posts: 57	You can draw buttons right on the sheet. View - Toolbar - Drawing. Now go to the bottom and click on autoshape. Click on any shape (shape is now in memory) and click anywhere on the sheet itself and the button is now there! Format it as you like by right click on the button to get the menu and assign the appropriate macro to it. [ This Message was edited by: mikeyboy on 2002-05-15 13:58 ]