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.
.