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,

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,

You could also use a hyperlink--either assigned to the button (from the Forms
toolbar) or just in a worksheet cell.

Souris wrote:

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,

--

Dave Peterson