software

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 quot;assign macroquot; option available when I right
click on the button, however it's not there.

Any ideas?

Thanks

Click the green triangle on the Controlbox Toolbar (design mode)
Right click your button.
gt;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.

HansYou 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:
gt;
gt; I have a macro that runs fine and I added a button to my spreadsheet from
gt; the forms control menu, but I can't figure out how to assign the macro to the
gt; button.
gt;
gt; I was expecting to see and quot;assign macroquot; option available when I right
gt; click on the button, however it's not there.
gt;
gt; Any ideas?
gt;
gt; Thanks

--

Dave Peterson