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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Command Button Excel 2007 4
'Cannot insert object' message when I try to put a button on a worksheet 7
Assign Function to a Command Button 1
Resetting up Excel 2003. Is there a fast simple way to re-associatemacros with macro buttons? 1
Assign Macro 7
Assigning Macro to a Command Button 3
losing command button functionality 4
macro does not assign to menu? 2

Back
Top