Macro and user created button Question?

[R Guzman]

Hello all. I wanted to ask about macros and buttons. By that I mean, I'm
creating a spread sheet that I want a user to click on button I created on
the spreadsheet, and trigger the macro.



Does anyone know how this can be done?



Thanks!

 

[Bob Phillips]

Create your macro.

On the worksheet, drag a button from the Forms toolbar onto the sheet. You
will be asked which macro to assign it to. Choose your new macro.

Done!

--

HTH

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

 

[R Guzman]

Thanks so much! Worked like a charm.

Create your macro.

On the worksheet, drag a button from the Forms toolbar onto the sheet. You
will be asked which macro to assign it to. Choose your new macro.

Done!

--

HTH

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