Written by Allen Wyatt (last updated August 21, 2021)
This tip applies to Excel 97, 2000, 2002, and 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:
Figure 1. The Toolbars tab of the Customize dialog box.
ExcelTips is your source for cost-effective Microsoft Excel training. This tip (2725) applies to Microsoft Excel 97, 2000, 2002, and 2003.
Program Successfully in Excel! John Walkenbach's name is synonymous with excellence in deciphering complex technical topics. With this comprehensive guide, "Mr. Spreadsheet" shows how to maximize your Excel experience using professional spreadsheet application development tips from his own personal bookshelf. Check out Excel 2013 Power Programming with VBA today!
Ever tried to clean-up the icons on your toolbar only to have one that won't go away? This tip explores some possible ...
Discover MoreAfter a time you may not need one of the custom toolbars you've created. This tip explains how to free up resources in ...
Discover MoreWant to get rid of a toolbar button? There's no need to drag open the menus and dialog boxes; just use the shortcut ...
Discover MoreFREE SERVICE: Get tips like this every week in ExcelTips, a free productivity newsletter. Enter your address and click "Subscribe."
2021-08-23 20:33:27
Allen
Richard,
No, it doesn't work in Office 2019. As it says at the end of the tip, "This tip (2725) applies to Microsoft Excel 97, 2000, 2002, and 2003."
In fact, this whole site is for older versions of Excel. If you want tips for the newer versions, see the notice at the top-right of every page on this site.
-Allen
2021-08-23 18:46:02
Richard Blunt
Does this work in Office 2019? I thought they discontinued it several years ago... :( I tried these steps hoping that maybe they brought it back but none of this worked for me. This looks like the way I used to do it in the old days :)
Got a version of Excel that uses the menu interface (Excel 97, Excel 2000, Excel 2002, or Excel 2003)? This site is for you! If you use a later version of Excel, visit our ExcelTips site focusing on the ribbon interface.
FREE SERVICE: Get tips like this every week in ExcelTips, a free productivity newsletter. Enter your address and click "Subscribe."
Copyright © 2025 Sharon Parq Associates, Inc.
Comments