"Assign Macro" is gone from menu
 

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

--
Message posted from http://www.ExcelForum.com

"Assign Macro" is gone from menu
 

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

"JustMe " wrote in
message ...
I've placed a command button on my worksheet and I want to
assign a
macro to it, but the menu on the "right click" popup window
does not
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 while
messing around in the Control Toolbar to disable that?


---
Message posted from http://www.ExcelForum.com/