Customizing Quick Access Toolbar Icons

Alan wonders if there a way in Excel 2007 to customize the icons available when adding macros or other items to the Quick Access toolbar. The short answer is that we can't find a way to add custom icons to the toolbar. You can select one of the built-in icons provided by Excel by following these steps:

1. Click the Office button and then click Excel Options. Excel displays the Excel Options dialog box.
2. At the left side of the dialog box click Customize.
3. Use the Choose Commands From drop-down list to choose Macros.
4. In the list of macros choose the one you want added to the Quick Action toolbar.
5. Click the Add button. The macro is copied to the right side of the screen.
6. On the right side of the screen, select the macro you just added.
7. Click Modify. Excel displays the Modify Button dialog box. (Click here to see a related figure.)
8. Select the graphic you want to use for your tool button.
9. Click OK.
10. Click OK to dismiss the Excel Options dialog box.

If you don't want to use one of the 181 buttons available in step 8, you are out of luck. It is possible to set up your own tabs on the ribbon, but such changes are beyond the scope of a simple tip and, in any case, it is unclear whether the same techniques used to change ribbon tabs will affect the Quick Access toolbar. (Thos interested in pursuing this area may want to refer to the excellent tutorials at http://www.rondebruin.nl/getimage.htm for more information.)