View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Ron de Bruin Ron de Bruin is offline
external usenet poster
 
Posts: 11,123
Default 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