Prev: Excel 2007, can't edit 2003 document
Next: Filter with criteria!
From: Premal on 15 Apr 2010 02:55
Can someone please tell me how to assign Macros to a Button?
From: ozgrid.com on 15 Apr 2010 04:37
http://www.ozgrid.com/Excel/assign-macros.htm



--
Regards
Dave Hawley
www.ozgrid.com
"Premal" <Premal(a)discussions.microsoft.com> wrote in message
news:026F76B8-CEC2-47B5-9581-66849F0627D8(a)microsoft.com...
> Can someone please tell me how to assign Macros to a Button?

From: Dave Peterson on 15 Apr 2010 07:45
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
 | 
Pages: 1
Prev: Excel 2007, can't edit 2003 document
Next: Filter with criteria!