Microsoft KB Archive/157027

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

Article ID: 157027

Article Last Modified on 10/21/2000

-

APPLIES TO


 * Microsoft Excel 97 Standard Edition

-



This article was previously published under Q157027





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.

