assigning a macro to a button
 

I have a macro that runs fine and I added a button to my spreadsheet from
the forms control menu, but I can't figure out how to assign the macro to the
button.

I was expecting to see and "assign macro" option available when I right
click on the button, however it's not there.

Any ideas?

Thanks

assigning a macro to a button
 

Click the green triangle on the Controlbox Toolbar (design mode)
Right click your button.
From the context menu select View Code
between the lines
Private sub
and End sub

type the name of your macro.

Turn off design mode and test it.

Hans

assigning a macro to a button
 

You added a commandbutton from the control toolbox. You can either follow
flummi's advice or delete that commandbutton and add a button from the Forms
toolbar.

Darby wrote:

I have a macro that runs fine and I added a button to my spreadsheet from
the forms control menu, but I can't figure out how to assign the macro to the
button.

I was expecting to see and "assign macro" option available when I right
click on the button, however it's not there.

Any ideas?

Thanks

--

Dave Peterson