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

[Steve]

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

 

[Ron de Bruin]

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

 

[Steve]

Thanks Ron.

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