Create button to run Macro?

J

Joe M.

I would like to use a button to run a macro but don't know how to do it. I
know how to create a button and record a macro but beyond that I need help.

Thanks,
Joe M.
 
B

Bob Phillips

Use the forms toolbar, Tools>Customize...>Toolbars and check the Forms
toolbar.

--
---
HTH

Bob


(there's no email, no snail mail, but somewhere should be gmail in my addy)
 
D

Dave Peterson

You already created the macro, right?

You put it in a General module--not behind a worksheet and not behind
ThisWorkbook, right?

If yes to both, then rightclick on the button from the Forms toolbar and select
Assign macro. You'll see a dialog where you can choose the macro you want.
 
Top