Adding your own toolbars

Applies to
Microsoft Excel 2000

If you don't want to modify the existing toolbars, you can add a new toolbar and then customize it with the buttons and commands you use most frequently.

Creating a new toolbar

To create your own toolbar:

  1. Click the Toolbars tab on the Customize dialog box.
  2. Click the New button, and then type a name for the toolbar.
  3. Click the Commands tab, and drag buttons and commands to the toolbar.

 Note   Adding commands to your own toolbar doesn't remove them from the existing toolbar where they normally appear.

Once created, you can display and hide your custom toolbar as you do any toolbar: right-click any toolbar or the menu bar, and then select or clear the check box for your custom toolbar.

Excel 2000 saves your custom toolbar, and any other toolbar and menu changes you've made, when you exit from Excel. Excel saves toolbar settings in file Excel.xlb, located in your user profile folder. For the location of this folder, type user profile folder in the Office Assistant or on the Answer Wizard tab in the Excel Help window, and then click Search.

 Tip   You can create and open different versions of this file to create more than one toolbar configuration or share a custom toolbar with other users. For more information, see How to use custom toolbars from previous versions of Excel.

Creating buttons for your macros and hyperlinks

If you use macros to automate tasks that you perform frequently, you can create your own toolbar buttons to run the macros. You can also create buttons that provide hyperlinks to files and Web pages that you use frequently.

Recording macros

For information about recording macros, type record a macro in the Office Assistant or on the Answer Wizard tab in the Excel Help window, and then click Search. If you want your macro button to be available whenever you use Excel, make sure you store it in the location recommended in the procedure.

Add a new button, or create your own

  1. On the Tools menu, click Customize.
  2. Click the Commands tab, click Macros, and drag the Custom Button item to the toolbar where you want a macro or hyperlink button.

Change the appearance of the custom button

Right-click the custom button, and do one of the following:

  • Click Change Button Image to select from a library of available images.
  • Click Edit Button Image to draw your own image.

Button Editor dialog box

Click a color, and then click or drag in the Picture area to draw your image. Use the Move buttons to shift the entire image within the Picture area.

You can also copy other button images or images from a bitmap editing program, such as Microsoft Windows® Paint, and then paste them onto a toolbar button. For the procedures, type customize toolbars and menus in the Office Assistant or on the Answer Wizard tab in the Excel Help window. Click Search, scroll to the bottom of the topic, and click "Change the appearance of a toolbar button."

Attach a macro or hyperlink to your button

To associate a macro with a button:

  1. Right-click the button (with the Customize dialog box displayed).
  2. Click Assign Macro, and then click the name of your macro in the Macro Name box.

To assign a hyperlink to a button:

  1. Right-click the button, point to Assign Hyperlink, and then click Open.
  2. Use the Assign Hyperlink: Open dialog box to locate and enter the address for the file or Web page you want to link to.

Returning to the default menus and toolbars

To undo your customized settings, you can reset individual toolbars and menus to their default contents, or you can reset all of the menus and toolbars at once.

Restoring menus

To restore the default commands to a menu, click Customize on the Tools menu, right-click the menu you want to restore, and then click Reset.

Resetting toolbars

To restore the default contents to a toolbar, click the Toolbars tab on the Customize dialog box, click the toolbar you want, and then click Reset.

 Note   You can't reset a custom toolbar that you've created, but you can delete custom toolbars that you no longer need.

Resetting all toolbar and menu changes

To return all customized settings to the Excel defaults, exit Excel and delete the Excel.xlb file from your user profile folder. For the location of this folder, type user profile folder in the Office Assistant or on the Answer Wizard tab in the Excel Help window, and then click Search. When you run Excel again, the defaults will be restored, and Excel will create a new copy of Excel.xlb for you.

More information

For more information about menus and toolbars, type about menus and toolbars in the Office Assistant or on the Answer Wizard tab in the Excel Help window, and then click Search. For customizing options and procedures, type toolbar in the Office Assistant or on the Answer Wizard tab in the Excel Help window, click Search, and then click "Customize menus and toolbars."

For information about making the Excel 2000 menus and toolbars behave like Excel 97 and earlier menus and toolbars, type restore 97 toolbars in the Office Assistant or on the Answer Wizard tab in the Excel Help window, and click Search.