XL97: Duplicate Toolbars Listed in Customize Dialog Box (167183)


The information in this article applies to:

  • Microsoft Excel 97 for Windows
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.
  2. 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.
  3. 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.

REFERENCES

For more information about customizing, click the Index tab in Microsoft Excel 97 Help, type the following text

customizing, toolbars

and then double-click the selected text to go to the "Settings Microsoft Excel can save in a template" topic.
Modification Type:MajorLast Reviewed:10/22/2000
Keywords:kbprb KB167183
©2002 Microsoft Corporation. All rights reserved.