Why won't Excel allow me to assign a macro to run from a command .

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

When I right click on a command button, I used to be able to assign a macro
to that command button from the shortcut menu. Now, "assign macro" isn't
even an option in my shortcut menu. Why?
 
Did you select "Customize" first? Whilst the Customize box is open, right
click on a selected button... Assign Macro should be the bottom most option.
 
Probably because you used a command button from the Controls Toolbox
Toolbar, not the Forms Toolbar.

ActiveX Controls run macros from their event code rather than being
assigned a macro to run on execute.
 
Hi

A commandbutton has a "click" macro already, choose "view code" and call
your macro from that one.

"Assign macro" is a choice for the Forms toolbar buttons, and for all
objects at the Drawing toolbar.

HTH. Best wishes Harald
 
Back
Top