Microsoft KB Archive/211861

= XL2000: Duplicate Toolbars Are Listed in the Customize Dialog Box =

Article ID: 211861

Article Last Modified on 11/5/2003

-

APPLIES TO


 * Microsoft Excel 2000 Standard Edition

-



This article was previously published under Q211861





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:
 * 1) On the View menu, point to Toolbars, and then click Customize.
 * 2) In the Customize dialog box, click the Toolbars tab. Select the toolbar with the name that contains an asterisk.
 * 3) Click Rename.
 * 4) 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:
 * 1) On the View menu, point to Toolbars, and then click Customize.
 * 2) In the Customize dialog box, click the Toolbars tab, and then select the extra toolbar in the Toolbars box.
 * 3) With the Customize dialog box displayed, click and drag each of the buttons from the extra toolbar to a new location on another toolbar.
 * 4) 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.

