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

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

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.

This is by design of Microsoft Excel 97.

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.

For more information about attaching toolbars to workbooks, click the Index tab in Microsoft Excel 97 Help, type the following text and then double-click the selected text to go to the "Attach a custom toolbar to a workbook" topic.