Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
button to execute macro
Excel 2002, following the instructions in Help, I create
a button to which I wish to assign a macro. Help tells me to right-click on the button and a menu selection will come up "Assign Macro." When I do this, no such menu selection comes up. The question is, how do I execute a macro using the button? Thanks for your help. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
button to execute macro
R.,
Right click your button again, does a menu selection "properties" appear? If so... you've used a button from the Control Toolbox toolbar when I believe what you wanted was a button from the Forms toolbar. Go View Toolbars and view the forms toolbar. Use a button from that toolbar, it should have the "Assign Macro" option. Dan E "R. Holland" wrote in message ... Excel 2002, following the instructions in Help, I create a button to which I wish to assign a macro. Help tells me to right-click on the button and a menu selection will come up "Assign Macro." When I do this, no such menu selection comes up. The question is, how do I execute a macro using the button? Thanks for your help. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
button to execute macro
You have created the button from the Controls toolbar. Delete the button and
make a new one from the Forms Toolbar. There is often a lot of confusion over this. HTH Anders Silvén "R. Holland" skrev i meddelandet ... Excel 2002, following the instructions in Help, I create a button to which I wish to assign a macro. Help tells me to right-click on the button and a menu selection will come up "Assign Macro." When I do this, no such menu selection comes up. The question is, how do I execute a macro using the button? Thanks for your help. |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
button to execute macro
Thanks for your help to Anders and Dan.
-----Original Message----- You have created the button from the Controls toolbar. Delete the button and make a new one from the Forms Toolbar. There is often a lot of confusion over this. HTH Anders Silvén "R. Holland" skrev i meddelandet ... Excel 2002, following the instructions in Help, I create a button to which I wish to assign a macro. Help tells me to right-click on the button and a menu selection will come up "Assign Macro." When I do this, no such menu selection comes up. The question is, how do I execute a macro using the button? Thanks for your help. . |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
button to execute macro
If you want to use the control button for your macro, then when you right
click on it, select View Code, you can then enter your macro under the Click sub created for you by vba. Took me ages to figure this out too !! :) Cheers Joe "Anders S" wrote in message ... You have created the button from the Controls toolbar. Delete the button and make a new one from the Forms Toolbar. There is often a lot of confusion over this. HTH Anders Silvén "R. Holland" skrev i meddelandet ... Excel 2002, following the instructions in Help, I create a button to which I wish to assign a macro. Help tells me to right-click on the button and a menu selection will come up "Assign Macro." When I do this, no such menu selection comes up. The question is, how do I execute a macro using the button? Thanks for your help. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Auto Execute Macro | Excel Worksheet Functions | |||
Button to execute Add-in | Excel Discussion (Misc queries) | |||
Cells turn 'hot' and execute distant macro button | Excel Discussion (Misc queries) | |||
Execute Macro | Excel Discussion (Misc queries) | |||
How do I execute command from button or hyperlink? | Excel Discussion (Misc queries) |