Copying buttons
 

Sounds like stephanie and I are living in parallel universes ---

I have 8 buttons on a worksheet that are local (private) to that sheet.
I want to copy them (and the code) to several other sheets. Is there
any way to do this without building them individually on each sheet? I
don't want to use the "copy sheet" function. Thanks

Copying buttons
 

No. You can just add them (use the macro recorder to see how) and add the code

http://www.cpearson.com/excel/vbe.htm

If you used buttons from the forms toolbar, you wouldn't have to do that.
You could design your macro to work with whichever button called it, so you
would only need to add the buttons and assign their onaction property to the
appropriate macro.

Who is Stephanie?

--
Regards,
Tom Ogilvy


"jim9912" wrote:

Sounds like stephanie and I are living in parallel universes ---

I have 8 buttons on a worksheet that are local (private) to that sheet.
I want to copy them (and the code) to several other sheets. Is there
any way to do this without building them individually on each sheet? I
don't want to use the "copy sheet" function. Thanks

Copying buttons
 

Thanks, I dont know why I didn't think of that. Thanks for the
timesaver.