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

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

-----Original Message-----
Amy,

Create the code on your spreadsheet and add a call in the
Workbook_Open to
run the code for the button when the spreadsheet is open.

Obviously that the macros will need to be enabled on the
other PC in order
to run that.
.

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...02&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/ba...n_addins97.htm
http://msdn.microsoft.com/library/of...exceladdin.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...b;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.



--
Regards,
Tom Ogilvy


"Amy" wrote in message
...
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

-----Original Message-----
Amy,

Create the code on your spreadsheet and add a call in the
Workbook_Open to
run the code for the button when the spreadsheet is open.

Obviously that the macros will need to be enabled on the
other PC in order
to run that.
.

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 ToolsCustomizeToolbars(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...EN-US;Q166755&

Gord Dibben Excel MVP




On Mon, 9 Aug 2004 12:56:16 -0700, "Amy"
wrote:

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

-----Original Message-----
Amy,

Create the code on your spreadsheet and add a call in the
Workbook_Open to
run the code for the button when the spreadsheet is open.

Obviously that the macros will need to be enabled on the
other PC in order
to run that.
.