Macros to Button

D

Dave Peterson

Use buttons from the Forms toolbar (View|Toolbars in xl2003 menus) to see that
toolbar.

Then click on the button and plop it on a sheet somewhere. You'll be prompted
to assign the macro right there. If you don't want to assign the macro then,
you can rightclick on the button and choose assign macro any time you want.

Remember, you'll want to put your macro into a General module -- not behind a
worksheet and not behind ThisWorkbook.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top