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.

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.

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.

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.