ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   in this version I can not attach a Macro to a Button (https://www.excelbanter.com/excel-discussion-misc-queries/35041-version-i-can-not-attach-macro-button.html)

Hussam Bachat

in this version I can not attach a Macro to a Button
 
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/m...icrosoft_offic
e_applications.htm

Rgds,
ScottO

"Hussam Bachat" <Hussam wrote in message
...
| 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/m...icrosoft_offic
e_applications.htm

S

"ScottO" wrote in message
...
| Take a look at this article by the esteemed Anne Troy ...
|
|
http://www.officearticles.com/misc/m...icrosoft_offic
| e_applications.htm
|
| Rgds,
| ScottO
|
| "Hussam Bachat" <Hussam wrote in message
| ...
| | 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.

--
HTH

Bob Phillips

"Hussam Bachat" <Hussam wrote in message
...
Can someone tell me how to attach a Macro to a Button from the design tool
bar ?





All times are GMT +1. The time now is 08:22 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com