Assign Macros to Buttons from Right-Click Menu

  • Thread starter Thread starter paperclip
  • Start date Start date
P

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

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

Regards
 
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
 
Genius! That was exactly it!

Thank you!!

Gord said:
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
 
Back
Top