The information in this article applies to:
SYMPTOMSIn Microsoft Excel 98 Macintosh Edition, 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. CAUSEThis problem may occur when either of the following conditions is true:
-or- WORKAROUNDTo ensure that the latest copy of your custom toolbar is saved with the workbook, you need to reattach the toolbar to the workbook every time that it is modified. To do this, follow these steps:
MORE INFORMATIONAttached Toolbar Is Not LoadedIf 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
the preexisting toolbar in the Microsoft Excel session will be displayed
rather than the recently attached toolbar.
Attached Toolbar Reverts to Previous VersionIf 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:
Additional query words: XL98
Keywords : kbdta xlui xltoolbar |
Last Reviewed: January 19, 2000 © 2000 Microsoft Corporation. All rights reserved. Terms of Use. |