Buttons

[Guest]

I have made a button in the ordinary Excel-interface by using
View>Toolbars>Forms. 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!!!

 

[Guest]

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

 

[Bob Phillips]

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)