Microsoft KB Archive/51565

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 Last reviewed: November 1, 1994 © 1998 Microsoft Corporation. All rights reserved. Terms of Use.