View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Bob Phillips[_6_] Bob Phillips[_6_] is offline
external usenet poster
 
Posts: 11,272
Default Customized components

If you get a button from the forms toolbar, you can assign a macro, so just
assign the same macro to every button.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Souris" wrote in message
...
I would like to place a button on more than one spreadsheet.
May I have a cusomized button that I need code once?

For example:

I need a button have following code onclick:

Sheets("MAIN").select

I can just replace the MAIN button on the form I need.

Any information is great appreciated,