Excel.Tips.Net Welcome toExcel.Tips.Net

Helpful Links

Tips.Net Home
ExcelTips Home
Ask an Excel Question
Make a Comment

Tips.Net Store

ExcelTips FAQ
ExcelTips Premium

Learn Access Now

Beauty Tips
Car Tips
Cleaning Tips
College Tips
Cooking Tips
Excel2007 Tips
ExcelTips
Family Tips
Gardening Tips
Health Tips
Home Tips
Money Tips
Organizing Tips
Pest Tips
Pet Tips
Wedding Tips
Word2007 Tips
WordTips

Advertise on the
ExcelTips Site

Newest Tips

Assigning a Macro to a Keyboard Combination

Creating Scenarios

Using Message Boxes

Understanding Phantom Macros

Picking a Group of Cells

Running Out of Memory

Hiding Rows Based on a Cell Value

 

Editing a Toolbar Button Image

Summary: Don't like the toolbar button images in your version of Excel? Don't fret; you can pull up the button editor and make changes pixel by pixel, if desired. (It's easier to do than you think, although you artistic talents may be tested in the process.) (This tip works with Microsoft Excel 97, Excel 2000, Excel 2002, and Excel 2003.)

In the previous tip you learned how you can change the image that appears on a toolbar button. Excel also includes a built-in editor that allows you to edit or completely change any toolbar button image, pixel by pixel, if desired. To access this editor, 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. (Right-click on the toolbar button itself, not within the dialog box.) Excel displays a Context menu.
  4. Choose Edit Button Image from the Context menu. Excel displays the Button Editor. (Click here to see a related figure.)
  5. Use the controls within the Button Editor to change how the image on the button appears.
  6. When satisfied with the appearance of the button, click on OK to close the Button Editor.
  7. Click on Close to get rid of the Customize dialog box.

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

Remove Some Stress at Tax Time! Doing your personal income taxes can be a royal pain. Why not make the process just a bit less stressful with our 101-question checklist. You can prepare for filing your taxes with confidence, knowing you've covered all your bases.
 
Check out Filing Your Income Taxes Checklist today!