Alan wonders if there a way 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:
- Display the Excel Options dialog box. (In Excel 2007 click the Office button and then click Excel Options. In Excel 2010 and Excel2013 display the File tab of the ribbon and then click Options.)
- At the left side of the dialog box click Customize (Excel 2007) or Quick Access Toolbar (Excel 2010 and 2013).
- Use the Choose Commands From drop-down list to choose Macros.
- In the list of macros choose the one you want added to the Quick Access Toolbar.
- Click the Add button. The macro is copied to the right side of the screen.
- On the right side of the screen, select the macro you just added.
- Click Modify. Excel displays the Modify Button dialog box. (See Figure 1.)
- Select the graphic you want to use for your tool button.
- Click OK.
- Click OK to dismiss the Excel Options dialog box.
Figure 1. The Modify Button 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. (Those interested in pursuing this area may want to refer to the excellent tutorials at http://www.rondebruin.nl/getimage.htm for more information.)