"Assign Macro" is gone from menu

  • Thread starter Thread starter JustMe
  • Start date Start date
J

JustMe

I've placed a command button on my worksheet and I want to assign
macro to it, but the menu on the "right click" popup window does no
have the "assign menu" on it like it says in Help.

How do I assign a macro to my command button? Did I do something whil
messing around in the Control Toolbar to disable that
 
You can't assign a macro to command buttons created from the
Controls toolbar. You can choose the "View Code" option from the
right-click menu, and call your macro from that procedure, or
create a command button from the Forms toolbar.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com
 
Back
Top