toolbar buttons

A

Amy

Is it possible to create toolbar buttons that will travel
with the spreadsheet when it is emailed to another
person? In this case it is much more convenient to have
the macro buttons on the toolbar than on the spreadsheet
itself, but they are lost when it is emailed to another
user. Is there a way around this?

Thank you,
Amy
 
A

Amy

Thank you. These macros need to be available to the user,
but not run upon opening. Is there a way to make the
buttons travel with the file?

Thank you again!
Amy
 
T

Tom Ogilvy

He means create your toolbars with code which is run in the workbook_open
event.

The other method is to attach the toolbar to the workbook.

some references:

http://support.microsoft.com/default.aspx?scid=kb;en-us;830502&Product=xlw
How to customize menus and menu bars in Excel

Here is an article which talks about attaching toolbars:

http://www.microsoft.com/exceldev/articles/toolbatt.htm

Here is an article about creating commandbars with code:
http://msdn.microsoft.com/library/techart/ofcmdbar.htm

Here is another article or two you might find useful:
http://msdn.microsoft.com/library/backgrnd/html/msdn_addins97.htm
http://msdn.microsoft.com/library/officedev/odeopg/deovrcreatingexceladdin.htm
http://www.microsoft.com/exceldev/tips/addins.htm
These are about distributing applications

http://support.microsoft.com/?id=159619
XL97: Sample Macros for Customizing Menus and Submenus

http://support.microsoft.com/?id=213550
XL2000: Sample Macros for Customizing Menus and Submenus


http://support.microsoft.com/default.aspx?scid=kb;en-us;166755
File Title: Customizing Menu Bars, Menus, and Menu Items in Microsoft(R)
Excel 97
File Name: WE1183.EXE
File Size: 58041 bytes
File Date: 06/20/97
Keywords: kbfile kbappnote
Description: This Application Note can help you learn techniques for writing
Visual Basic(R) for Applications code to customize menus in Microsoft Excel
97. This Application Note contains code examples that you can use with the
following elements: menu bars, menus, menu items, submenus, and shortcut
menus.
 
G

Gord Dibben

Amy

The workbook_open code is to build the Toolbar with the buttons on it, not run
the macros.

Currently, if the buttons are on their own Toolbar.........

Attaching the Toolbar through Tools>Customize>Toolbars(select your
toolbar)>Attach.

It will travel with the workbook.

Alternative.........create the Toolbar when the file is opened.

This would involve some VBA coding in Workbook-Open Sub

For examples see.....

http://support.microsoft.com/default.aspx?scid=KB;EN-US;Q166755&

Gord Dibben Excel MVP
 
Top