Microsoft KB Archive/167183

= XL97: Duplicate Toolbars Listed in Customize Dialog Box =

Article ID: 167183

Article Last Modified on 10/22/2000

-

APPLIES TO


 * Microsoft Excel 97 Standard Edition

-



This article was previously published under Q167183



SYMPTOMS
When you right-click a toolbar to view the shortcut menu, duplicate toolbar names may appear. When this occurs, Microsoft Excel lists one of the toolbars with an asterisk (*) after the toolbar name. Additionally, some of the toolbar buttons with names that contain an asterisk may appear without a graphic image.



CAUSE
This behavior occurs when the following conditions are both true:
 * You upgrade from an earlier version of Microsoft Excel. -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 problem, use either of the following methods.

Method 1: Rename the Toolbar
To rename the toolbar, do the following:
 * 1) On the View menu, point to Toolbars and click Customize. In the Customize dialog box, click the toolbar with the name that contains an asterisk.
 * 2) Click Rename.
 * 3) In the Rename Toolbar dialog box, type a new name for your toolbar. Click OK and click Close.

NOTE: you cannot rename a built-in toolbar.

Method 2: Consolidate the Two Toolbars into One
To consolidate the toolbars, do the following:
 * 1) If the duplicated toolbars are not visible, point to Toolbars on the View menu, and then click Customize. In the Customize dialog box, click to select the check box next to the toolbar tab.

NOTE: Do not click Close yet.
 * 1) With the Customize dialog box displayed, click and drag each of the buttons from the toolbar with the name that contains an asterisk to the other toolbar.
 * 2) In the Customize dialog, click the toolbar with the name that contains an asterisk and click Delete.

NOTE: you cannot delete a built-in toolbar.



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

