Thread: Buttons
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Paul Mathews Paul Mathews is offline
external usenet poster
 
Posts: 84
Default Buttons

Right-click on the button, choose "Assign macro...", then select the macro
you want to attach to the button from the macros list.

"april27" wrote:

I have made a button in the ordinary Excel-interface by using
ViewToolbarsForms. The button is supposed to call a larger program that I
have in a modul. However, I fail to connect the button to the macro. The
button is placed in Sheet1. In VisualBasic for Sheet1 I have the following
code:

Private Sub main_program_button_Click()
Call mainProgram
End Sub

The main program is found in the modul. Since I created the button in Excel
I do not know how to get the code descibed above to connect to the button.
Please help needed!!!