Changing a Toolbar Button Image

Summary: Excel allows you to modify virtually all aspects of its user interface. One of the things you can change is the images used for almost all toolbar buttons. This tip explains how easy it is to change button images. (This tip works with Microsoft Excel 97, Excel 2000, Excel 2002, and Excel 2003.)

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:

Right-click on any toolbar visible in Excel. Excel displays a Context menu.
Choose Customize from the Context menu. Excel displays the Customize dialog box with the Toolbars tab selected. (Click here to see a related figure.)
Right-click on the toolbar button you want to modify. Excel displays a Context menu.
Choose Change Button Image from the Context menu. Excel displays a list of available graphic images you can use.
Click on the graphic image you want to use. The image appears on the toolbar button.
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.
Right-click on the toolbar button you want to modify. Excel displays a Context menu.
Choose Default Style from the Context menu. The toolbar button changes to only an image.
Click on Close to get rid of the Customize dialog box.

ExcelTips is your source for cost-effective Microsoft Excel training. This tip (2725) applies to Microsoft Excel versions: 97 | 2000 | 2002 | 2003

Make Home Buying Less Stressful! Why make home buying harder than it needs to be? Put your mind at ease—discover all the questions you need to ask to make the best buying decision.

Check out Buying a Home Checklist today!

Helpful Links

Newest Tips

Subscribe

RSS Feeds

Changing a Toolbar Button Image