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

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

Forms buttons are linked via a macro assign. Right-click the button, and
select Assign Macro from there.

--

HTH

Bob Phillips

(replace xxxx in the email address with gmail if mailing direct)

"april27" wrote in message
...
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!!!