Macro Buttons
 

Does anyone know how I can insert a button into a worksheet and then
have that button, once pressed, execute a macro that I have just
recorded. Thanks.


------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~View and post usenet messages directly from http://www.ExcelForum.com/

Macro Buttons
 

This should work if you are using a VB command button.
Just put the name of a macro in the Click sub

Private Sub CommandButton1_Click()
Macro1
End Sub



"jpx" wrote in message
...

Does anyone know how I can insert a button into a worksheet and then
have that button, once pressed, execute a macro that I have just
recorded. Thanks.


------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~View and post usenet messages directly from http://www.ExcelForum.com/