assigning a macro to a button

D

Darby

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
 
F

flummi

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

type the name of your macro.

Turn off design mode and test it.

Hans
 
D

Dave Peterson

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.
 
Top