Microsoft KB Archive/51565

{| = Excel: Standard Menu Not Updating After Using Custom Menu Bar =
 * width="100%"|

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.
 * }