XL2000: Duplicate Toolbars Are Listed in the Customize Dialog Box (211861)

SYMPTOMS

If you right-click a toolbar to view a shortcut menu, duplicate toolbar names may appear. Microsoft Excel lists one of the toolbars with an asterisk (*) after the toolbar name. Additionally, some of the toolbar buttons appear without a graphic image. In some cases, extra toolbars are added; they are named Toolbar 1, Toolbar 2, Toolbar 3, and so on. Each of the new toolbars contains only one button.

CAUSE

This behavior can occur when the following conditions are true:

You upgrade to Microsoft Excel 2000 from a version earlier than Microsoft Excel 97.

-and-
You save a custom toolbar file in your Windows folder with your logon name. For example, you name the toolbar JohnD.xlb.

RESOLUTION

To resolve this issue, use either of the following methods.

Method 1: Rename the Toolbar

To rename the toolbar, follow these steps:

On the View menu, point to Toolbars, and then click Customize.
In the Customize dialog box, click the Toolbars tab. Select the toolbar with the name that contains an asterisk.
Click Rename.
In the Rename Toolbar dialog box, type a new name for your toolbar. Click OK, and then click Close.

NOTE: You cannot rename a built-in toolbar.

Method 2: Consolidate the Extra Toolbars

To consolidate the toolbars, follow these steps:

On the View menu, point to Toolbars, and then click Customize.
In the Customize dialog box, click the Toolbars tab, and then select the extra toolbar in the Toolbars box.
With the Customize dialog box displayed, click and drag each of the buttons from the extra toolbar to a new location on another toolbar.
In the Customize dialog box, select the extra toolbar that is no longer required, and then click Delete.

NOTE: You cannot delete a built-in toolbar.

MORE INFORMATION

Any toolbar file (.xlb file) that is stored in your Windows folder is integrated into the default toolbar file when you install a new version of Excel. This behavior is designed to preserve the previous toolbars. However, if you customize a built-in toolbar, such as the standard toolbar or Formatting toolbar, Excel installs the built-in toolbar that contains the default buttons and appends an asterisk to the name of your customized toolbar.

REFERENCES

For more information about customizing, click Microsoft Excel Help on the Help menu, type customize menus and toolbars in the Office Assistant or the Answer Wizard, and then click Search to view the topic.