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.

Use the forms toolbar, ToolsCustomize...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." wrote in message
...
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.

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

"Bob Phillips" wrote:

Use the forms toolbar, ToolsCustomize...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." wrote in message
...
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.

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.

Joe M. wrote:

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

"Bob Phillips" wrote:

Use the forms toolbar, ToolsCustomize...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." wrote in message
...
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.





--

Dave Peterson