Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default "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

  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 7,247
Default "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/



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Lost "File Menu" - now it's "Edit / View / Insert.." but no "F daves Excel Discussion (Misc queries) 3 April 24th 07 04:52 AM
Sheets("Rpt").Copy different results from running in macro than off excel menu?? tmbo Excel Discussion (Misc queries) 7 August 9th 06 01:13 PM
"assign macro" not an option from short menu SteveJ Excel Discussion (Misc queries) 2 May 18th 06 05:55 PM
if "a" selected from dropdown menu then show "K" in other cell LEGALMATTERS Excel Worksheet Functions 1 April 13th 06 06:05 PM
Macro for "Retrieve" in Essbase Menu Jelso Excel Programming 1 September 11th 03 09:12 AM


All times are GMT +1. The time now is 01:16 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"