XL97: How to Use Custom Toolbars in Excel5.xlb

Article ID: 161322 - View products that this article applies to.
This article was previously published under Q161322
Expand all | Collapse all

SYMPTOMS

When you upgrade Microsoft Excel 5.0 to Microsoft Excel 97, any built-in toolbar you customize or custom toolbar you create in Microsoft Excel 5.0 does not appear in Microsoft Excel 97.

CAUSE

Microsoft Excel 97 does not convert Microsoft Excel 5.0 toolbars that are stored in the Excel5.xlb file.

RESOLUTION

To use toolbars that stored in the Excel5.xlb file, do the following:
  1. Start Microsoft Excel 97.
  2. On the File menu, click Open.
  3. Locate the Excel5.xlb file in the Windows folder and select it.
  4. Click Open.

    Microsoft Excel does not open a workbook but does load the toolbars into random access memory (RAM).
  5. On the View menu, point to Toolbars, and then click the name of any toolbar you created in Microsoft Excel 5.0.
NOTE: If the Excel5.xlb file contains one of the built-in toolbars, the toolbar name that appears on the Toolbars menu is followed by an asterisk. For example, the Standard toolbar appears as Standard*.

STATUS

This behavior is by design of Microsoft Excel 97.

MORE INFORMATION

For additional information, please see the following article in the Microsoft Knowledge Base:
125183 XL: Default Toolbars and Toolbar Buttons Seen Instead of Customizations

REFERENCES

For more information about Toolbar Files, click the Index tab in Microsoft Excel 97 Help, type the following text
toolbars, multiple configurations
and then double-click the selected text to go to the "Save more than one toolbar configuration" topic.

Properties

Article ID: 161322 - Last Review: August 29, 2001 - Revision: 1.0
APPLIES TO
  • Microsoft Excel 97 Standard Edition
Keywords: 
kbsetup KB161322
Retired KB Content Disclaimer
This article was written about products for which Microsoft no longer offers support. Therefore, this article is offered "as is" and will no longer be updated.

Give Feedback