Excel: Standard Menu Not Updating After Using Custom Menu Bar

Last reviewed: November 1, 1994
Article ID: Q51565

SUMMARY

When a custom menu bar is used in a Microsoft Excel macro and the standard menu bar is then returned to, the standard menu bar is not updated to reflect any changes that have been made. For example, if a document has been protected, Protect Document will still appear on the Options menu instead of Unprotect Document.

The state of the standard menu bar is not updated while a custom menu bar is being displayed. To force the standard menu bar to update after it is displayed, use the following commands in your macro:

   =SHORT.MENUS(TRUE)
   =SHORT.MENUS(FALSE)

This will place the menu bar in short menus and then return it to full menus, causing the menus to update.

KBCategory: kbother
KBSubcategory:
Additional reference words: 2.20

THE INFORMATION PROVIDED IN THE MICROSOFT KNOWLEDGE BASE IS PROVIDED "AS IS" WITHOUT WARRANTY OF ANY KIND. MICROSOFT DISCLAIMS ALL WARRANTIES, EITHER EXPRESS OR IMPLIED, INCLUDING THE WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE. IN NO EVENT SHALL MICROSOFT CORPORATION OR ITS SUPPLIERS BE LIABLE FOR ANY DAMAGES WHATSOEVER INCLUDING DIRECT, INDIRECT, INCIDENTAL, CONSEQUENTIAL, LOSS OF BUSINESS PROFITS OR SPECIAL DAMAGES, EVEN IF MICROSOFT CORPORATION OR ITS SUPPLIERS HAVE BEEN ADVISED OF THE POSSIBILITY OF SUCH DAMAGES. SOME STATES DO NOT ALLOW THE EXCLUSION OR LIMITATION OF LIABILITY FOR CONSEQUENTIAL OR INCIDENTAL DAMAGES SO THE FOREGOING LIMITATION MAY NOT APPLY.

Last reviewed: November 1, 1994
© 1998 Microsoft Corporation. All rights reserved. Terms of Use.