Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Hussam Bachat
 
Posts: n/a
Default 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 ?
  #2   Report Post  
ScottO
 
Posts: n/a
Default

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 ?


  #3   Report Post  
ScottO
 
Posts: n/a
Default

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 ?
|
|


  #4   Report Post  
Bob Phillips
 
Posts: n/a
Default

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 ?



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Formula for current month minus one = Quarter number in a macro. Pank Excel Discussion (Misc queries) 11 June 22nd 05 02:47 PM
Help with macro looping and color query function kevinm Excel Discussion (Misc queries) 10 May 26th 05 01:25 AM
How do you attach a macro in excel 2003? James Excel Discussion (Misc queries) 1 April 21st 05 04:51 PM
Playing a macro from another workbook Jim Excel Discussion (Misc queries) 1 February 23rd 05 10:12 PM
Date macro Hiking Excel Discussion (Misc queries) 9 February 3rd 05 12:40 AM


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

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"