Thread: Buttons

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

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

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" <april27@discussions.microsoft.com> wrote in message
news:EBB1967D-C469-4A4B-946B-9CAF58EE9635@microsoft.com...
> 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!!!