XL97: Attached Toolbar Is Not Saved in 5.0/95 File Format

• Microsoft Excel 97 for Windows

SYMPTOMS

In Microsoft Excel 97, when you save a workbook, a custom toolbar that is attached to the workbook may not be saved.

CAUSE

This behavior occurs when you save the workbook in the "Microsoft Excel 5.0/95 Workbook(*.xls)" file format.

NOTE: If you save the workbook in the "Microsoft Excel Workbook(*.xls)" file format, an attached toolbar is saved with the workbook.

STATUS

This is by design of Microsoft Excel 97.

MORE INFORMATION

In Microsoft Excel 97, you can attach custom toolbars to workbooks. If a workbook contains an attached toolbar, the toolbar is available to every user who opens the workbook.

To attach a custom toolbar to a workbook, use the following steps:

1. On the View menu, point to Toolbars, and click Customize.

2. Click Attach.

3. In the list of Custom Toolbars, select a toolbar that you want to attach to the active workbook, and click Copy. Repeat this step for each toolbar you want to attach to the workbook.

4. Click OK, and then click Close.

REFERENCES

For more information about attaching toolbars to workbooks, click the Index tab in Microsoft Excel 97 Help, type the following text

   toolbars, workbooks