Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Assign a Macro feature not showing
Good day. I am using Excel 2002 on Windows XP Pro. I have a worksheet that
I have added a Command Button to. I have printed out the instructions for assigning a Macro to this button, but when I select the button and right-click the sizing handles, the Assign a Macro feature does not show in the list of features. The Macro was created and attached to "this worksheet" prior to creating the command button. Am I missing something? Thanks for any help provided. Danno... |
#2
|
|||
|
|||
On Fri, 7 Oct 2005 08:02:02 -0700, "Danno"
wrote: Good day. I am using Excel 2002 on Windows XP Pro. I have a worksheet that I have added a Command Button to. I have printed out the instructions for assigning a Macro to this button, but when I select the button and right-click the sizing handles, the Assign a Macro feature does not show in the list of features. The Macro was created and attached to "this worksheet" prior to creating the command button. Am I missing something? Thanks for any help provided. Danno... Sounds like you're trying to use the Activex control which doesn't allow macros. Use the Excel Controls instead. Make sure the Forms toolbar is visible. John Walkenbach's site explains this extremely well. http://www.j-walk.com/ss/excel/tips/tip84.htm HTH __ Richard Buttrey Grappenhall, Cheshire, UK __________________________ |
#3
|
|||
|
|||
Good day Richard, Thanks for the quick and accurate reply. As always, the
members of this group get me out of trouble. Danno... "Richard Buttrey" wrote: On Fri, 7 Oct 2005 08:02:02 -0700, "Danno" wrote: Good day. I am using Excel 2002 on Windows XP Pro. I have a worksheet that I have added a Command Button to. I have printed out the instructions for assigning a Macro to this button, but when I select the button and right-click the sizing handles, the Assign a Macro feature does not show in the list of features. The Macro was created and attached to "this worksheet" prior to creating the command button. Am I missing something? Thanks for any help provided. Danno... Sounds like you're trying to use the Activex control which doesn't allow macros. Use the Excel Controls instead. Make sure the Forms toolbar is visible. John Walkenbach's site explains this extremely well. http://www.j-walk.com/ss/excel/tips/tip84.htm HTH __ Richard Buttrey Grappenhall, Cheshire, UK __________________________ |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Assign Macro | Excel Discussion (Misc queries) | |||
Assign a macro to Command Button Object | Excel Discussion (Misc queries) | |||
Assign to macro missing | Excel Discussion (Misc queries) | |||
How to assign a macro to a commnd button | Excel Discussion (Misc queries) | |||
assign a macro to a control button | Excel Discussion (Misc queries) |