| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Linking a Macro to a Button
Having a brain cramp.
How do I trigger an existing macro with a button object? I am using the Control Toolbox to create the button, then I'm lost. Thanks. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Linking a Macro to a Button
You may be better to use a button from the Forms toolbar, and then you can
right-click the button and assign your macro to it. -- HTH Bob Phillips (remove nothere from email address if mailing direct) "bman342" wrote in message ... Having a brain cramp. How do I trigger an existing macro with a button object? I am using the Control Toolbox to create the button, then I'm lost. Thanks. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Linking a Macro to a Button
Use the 'Forms' Toolbar rather than the 'Controls' toolbar, when you create
your button a dialog will appear asking you whic macro you want to associate with the button. HTH Neil www.nwarwick.co.uk "bman342" wrote: Having a brain cramp. How do I trigger an existing macro with a button object? I am using the Control Toolbox to create the button, then I'm lost. Thanks. |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Linking a Macro to a Button
Thanks to both who replied.
"Neil" wrote: Use the 'Forms' Toolbar rather than the 'Controls' toolbar, when you create your button a dialog will appear asking you whic macro you want to associate with the button. HTH Neil www.nwarwick.co.uk "bman342" wrote: Having a brain cramp. How do I trigger an existing macro with a button object? I am using the Control Toolbox to create the button, then I'm lost. Thanks. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Cells turn 'hot' and execute distant macro button | Excel Discussion (Misc queries) | |||
| assigning macro to button | Excel Discussion (Misc queries) | |||
| Macro linking | Excel Discussion (Misc queries) | |||
| Attaching a macro to a VB button on a form | Excel Worksheet Functions | |||
| Assigning a macro to a "button" | Excel Discussion (Misc queries) | |||
Linear Mode
