Hi,

One way would be to create a toolbar instead.

Second way:
To do this, i think it is easier with button from the Forms toolbar instead
of the Control Toolbox toolbar assuming that every Button1 on each sheet call
the same macro:
- Buttons from Forms: you link them to a m,acro that is in a code module.
That is several button can call the same macro easily. No code in the sheet
module.
- buttons from Control Toolbox: they react to a clik and the _Click sub has
to be in the sheet containing the button. Some code has to be in the sheet.

Assuming you are using these buttons from the Forms toolbar:
- link to macros:
-right click each button, choose Assign Macro and pick a macro from the
list (public macros in modules)
- Group them together:
- from the Drawing toolbar, click the Arrow icon to enter Drawing mode,
so that you can select multiple shapes at once.
- grab the buttons, they become selected
- from the Drawing Toolbar, choose menu Draw Group
- click the Arrow from the Drawing toolbar again to leave the drawing mode.
The buttons are now grouped.
- Copy/Paste to other sheets:
- right the group of buttons, choose Copy from the pop-up menu
- go to another sheet and paste
The buttons are now pasted in the other sheet and they have the same
functionality (they call the same macros when clicked)

i hope this helps,
--
Regards,
Sébastien


"Rick" wrote:

I have command buttons on one worksheet within a workbook spreadsheet. I
want these same buttons to remain as I move from one worsheet to another
within the same spreadsheet. Has anyone done this? Thanks