Thread: Macro Buttons
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Mike Tomasura Mike Tomasura is offline
external usenet poster
 
Posts: 32
Default 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/