Excel: Standard Menu Not Updating After Using Custom Menu BarLast reviewed: November 1, 1994 |
SUMMARYWhen 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 Last reviewed: November 1, 1994 |