in this version I can not attach a Macro to a Button

[Guest]

Can someone tell me how to attach a Macro to a Button from the design tool
bar ?

 

[ScottO]

Take a look at this article by the esteemed Anne Troy ...

http://www.officearticles.com/misc/methods_to_run_a_macro_in_microsoft_offic
e_applications.htm

Rgds,
ScottO

| Can someone tell me how to attach a Macro to a Button from the design tool
| bar ?

 

[ScottO]

Sorry, the link got chopped for some reason ...

http://www.officearticles.com/misc/methods_to_run_a_macro_in_microsoft_offic
e_applications.htm

S

| Take a look at this article by the esteemed Anne Troy ...
|
|
http://www.officearticles.com/misc/methods_to_run_a_macro_in_microsoft_offic
| e_applications.htm
|
| Rgds,
| ScottO
|
| | | Can someone tell me how to attach a Macro to a Button from the design
tool
| | bar ?
|
|

 

[Bob Phillips]

By design toolbar, I assume you mean the control toolbar.

With this button, you don't directly assign macros, you run event macros. If
you go into design mode, click the blue-green triangle on the toolbar,
double-click the button, and it will open a code window, with a template
event for that button. Add your code to that event macro, or just call your
macro from within it.