Excel 2007 - Can Macros be added to the Quick Access Toolbar
 

Excel 2007 was loaded onto my PC at work this week. Is it possible to
assign macros to a custom button on the Quick Access Toolbar? I have added
Excel commands to the Quick Access Toolbar, but I can't figure out how to
add macros that I have written to the toolbar. I've looked in help, but so
far no luck.

I've done this in Excel 2000, but I don't see how to do this in 2007.

Thanks.

Steve

Excel 2007 - Can Macros be added to the Quick Access Toolbar
 

Hi Steve

If you select "Macros" In the "Choose commands from" dropdown and add a macro button to the QAT you are able to use the Modify
button to choose from 181 images (there are 1871 images) but you do not have
this option for built-in buttons.

More info here
http://www.rondebruin.nl/imageqat.htm


--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"Steve" wrote in message ...
Excel 2007 was loaded onto my PC at work this week. Is it possible to
assign macros to a custom button on the Quick Access Toolbar? I have added
Excel commands to the Quick Access Toolbar, but I can't figure out how to
add macros that I have written to the toolbar. I've looked in help, but so
far no luck.

I've done this in Excel 2000, but I don't see how to do this in 2007.

Thanks.

Steve

Excel 2007 - Can Macros be added to the Quick Access Toolbar
 

Thanks Ron.


"Ron de Bruin" wrote in message
...
Hi Steve

If you select "Macros" In the "Choose commands from" dropdown and add a
macro button to the QAT you are able to use the Modify button to choose
from 181 images (there are 1871 images) but you do not have
this option for built-in buttons.

More info here
http://www.rondebruin.nl/imageqat.htm


--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"Steve" wrote in message
...
Excel 2007 was loaded onto my PC at work this week. Is it possible to
assign macros to a custom button on the Quick Access Toolbar? I have
added Excel commands to the Quick Access Toolbar, but I can't figure out
how to add macros that I have written to the toolbar. I've looked in
help, but so far no luck.

I've done this in Excel 2000, but I don't see how to do this in 2007.

Thanks.

Steve