Macros to Button
 

Can someone please tell me how to assign Macros to a Button?

Macros to Button
 

http://www.ozgrid.com/Excel/assign-macros.htm



--
Regards
Dave Hawley
www.ozgrid.com
"Premal" wrote in message
...
Can someone please tell me how to assign Macros to a Button?

Macros to Button
 

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.

Premal wrote:

Can someone please tell me how to assign Macros to a Button?

--

Dave Peterson