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!!!
|