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

L

ltinda01

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?
 
S

swatsp0p

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

JE McGimpsey

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

Harald Staff

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
 
Top