Changing a Toolbar Button Image

Excel provides you with quite a bit of flexibility in how your toolbars appear. You can change the appearance of your toolbar buttons so they accurately reflect how you want Excel to appear. For instance, you may have added a custom macro to a toolbar, and you want to change it so that a graphic appears on the toolbar button instead of the macro name. Follow these steps:

1. Right-click on any toolbar visible in Excel. Excel displays a Context menu.
2. Choose Customize from the Context menu. Excel displays the Customize dialog box with the Toolbars tab selected. (Click here to see a related figure.)
3. Right-click on the toolbar button you want to modify. Excel displays a Context menu.
4. Choose Change Button Image from the Context menu. Excel displays a list of available graphic images you can use.
5. Click on the graphic image you want to use. The image appears on the toolbar button.
6. If you want to get rid of the text that appears on the toolbar button, continue with the next step, otherwise, skip to step 9.
7. Right-click on the toolbar button you want to modify. Excel displays a Context menu.
8. Choose Default Style from the Context menu. The toolbar button changes to only an image.
9. Click on Close to get rid of the Customize dialog box.