XL97: How to Use Custom Toolbars in Excel5.xlb

ID: Q161322

The information in this article applies to:

Microsoft Excel 97 for Windows

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:

   ARTICLE-ID: Q125183
   TITLE     : XL: Items Stored in the Toolbar File

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.

Additional query words: XL97

Keywords          : kbsetup kbtool xlui xltoolbar 
Version           : WINDOWS:97
Platform          : WINDOWS

Last Reviewed: November 1, 1998