Microsoft KB Archive/125847

= Unexpected Behavior with Attached Toolbars =

Article ID: 125847

Article Last Modified on 8/15/2005

-

APPLIES TO


 * Microsoft Excel 97 Standard Edition
 * Microsoft Excel 95 Standard Edition
 * Microsoft Excel 5.0 Standard Edition

-



This article was previously published under Q125847




 * Microsoft Excel for Windows NT 5.0|5.0
 * Microsoft Excel for the Macintosh 5.0|5.0





SYMPTOMS
In Microsoft Excel, custom toolbars can be attached to workbooks to allow the toolbar to be stored in the document, and these toolbars can be made available when the document is opened. However, the attached toolbar may not appear as expected.



CAUSE
This problem may occur when either of the following conditions is true:
 * The attached toolbar is not loaded. -or-


 * The attached toolbar reverts to a previous version.

For more information about these conditions, see the appropriate section in the "More Information" section later in this article.



WORKAROUND
To ensure that the latest copy of your custom toolbar is saved with the workbook, you must click Attach Toolbars on the Tools menu and recopy the toolbar to the worksheet each time you modify the toolbar.



Attached Toolbar Is Not Loaded
If a custom toolbar attached to a workbook has the same name as an existing custom toolbar in the current Microsoft Excel session, the attached toolbar will not replace the existing toolbar when the workbook is opened. Any Visual Basic macro code that references the attached toolbar will instead reference the pre-existing toolbar. For example, if a currently running Microsoft Excel session has an existing toolbar named "My Toolbar," and you open a file that has an attached toolbar also named "My Toolbar," Microsoft Excel will not load "My Toolbar" from the file. If a Visual Basic macro subsequently issues the command   Toolbars("My Toolbar").Visible=True the preexisting toolbar in the Microsoft Excel session will be displayed rather than the recently attached toolbar.

Attached Toolbar Reverts to Previous Version
If you attach a custom toolbar to a workbook, modify it, and then save the workbook, the attached toolbar will not reflect any changes made after the toolbar has been attached. You will not notice this behavior until you open the workbook on a different computer. For example, you will notice this problem if you do the following:


 * 1) Create a custom toolbar named "My Toolbar" that has two buttons.
 * 2) Attach this toolbar to a workbook.
 * 3) Add a third button to My Toolbar.
 * 4) Save and close the workbook.

If you do not delete "My Toolbar" in the current session of Microsoft Excel, and if you reopen the file, the attached toolbar will not be loaded and three buttons will be seen on "My Toolbar." However, if you open the workbook in a different installation of Microsoft Excel (on another computer, for example) that does not contain a custom toolbar named "My Toolbar," the attached toolbar will be loaded, and "My Toolbar" will display the two buttons that were present at the time it was attached to the worksheet.

