Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Button Confusion
I added a button to my worksheet in order to run a macro that I recorded. When I right click the button I am used to seeing the following as my options: - Cut - Copy - Paste - Edit Text - Grouping - Order - Assign Macro - Format Control But instead I am now finding the following when I right click: - Cut - Copy - Paste - Properties - View Code - Command Button Object - Grouping - Order - Format Control Where's the Edit Text and the Assign Macro? What am I doing wrong? Thanks. -- LACA ------------------------------------------------------------------------ LACA's Profile: http://www.excelforum.com/member.php...o&userid=30381 View this thread: http://www.excelforum.com/showthread...hreadid=561660 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Button Confusion
You normally add a button from the Forms toolbar, you have now added a
button from the Control Toolbox. They are different beasts. The control toolbox button is event driven, it doesn't have an assigned macro. If you go into design mode, click the blue-green triangle on the control toolbox toolbar, you will be taken to the code module for that sheet, where you can tap into the events for that button. -- HTH Bob Phillips (replace xxxx in the email address with gmail if mailing direct) "LACA" wrote in message ... I added a button to my worksheet in order to run a macro that I recorded. When I right click the button I am used to seeing the following as my options: - Cut - Copy - Paste - Edit Text - Grouping - Order - Assign Macro - Format Control But instead I am now finding the following when I right click: - Cut - Copy - Paste - Properties - View Code - Command Button Object - Grouping - Order - Format Control Where's the Edit Text and the Assign Macro? What am I doing wrong? Thanks. -- LACA ------------------------------------------------------------------------ LACA's Profile: http://www.excelforum.com/member.php...o&userid=30381 View this thread: http://www.excelforum.com/showthread...hreadid=561660 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Button Confusion
oh yeah, that was it. Many thanks. -- LACA ------------------------------------------------------------------------ LACA's Profile: http://www.excelforum.com/member.php...o&userid=30381 View this thread: http://www.excelforum.com/showthread...hreadid=561660 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Insert Options button doesn't disappear | Excel Discussion (Misc queries) | |||
Command Button Assignment | Excel Discussion (Misc queries) | |||
Runing two macros triggered by a button | Excel Discussion (Misc queries) | |||
Command Button anomalies | Excel Discussion (Misc queries) | |||
Macro to simply bring up the Find dialogue box?? | Excel Discussion (Misc queries) |