Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2007 Quick Access Toolbar Resets each day | Excel Discussion (Misc queries) | |||
How do I hide the Quick Access Toolbar in Excel 2007? | Excel Discussion (Misc queries) | |||
hide 0 values in quick access toolbar (Excel 2007) | Excel Worksheet Functions | |||
Excel 2007 - Auto Sum Icon in Quick Access Toolbar | Excel Worksheet Functions | |||
Excel 2007 Quick Access Toolbar Changes not Saved | Excel Discussion (Misc queries) |