Assign Macros to Buttons from Right-Click Menu

[paperclip]

I have an odd problem.

I no longer have the option to assign macros in the right-click contex
menu.
When I create a custom button on an excel sheet and then enter desig
mode, usually you can just record a macro, right click a button an
assign a macro. I cant seem to find the option to assign macros t
buttons!

Any help on enabling this option in the right-click contextual men
would be much appreciated.

Regards

 

[Gord Dibben]

If you create the button using the Forms Toolbar you will get the "Assign Macro"
available.

When creating using the Control Toolbox, you must right-click on the button and
"View Code".

Add your macro code there.


Gord Dibben MS Excel MVP

 

[paperclip]

Genius! That was exactly it!

Thank you!!

If you create the button using the Forms Toolbar you will get the
"Assign Macro"
available.

When creating using the Control Toolbox, you must right-click on the
button and
"View Code".

Add your macro code there.


Gord Dibben MS Excel MVP