Create button to run Macro?

[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.

 

[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)

 

[Joe M.]

I have the button created but how do I make it run the macro?

 

[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.