Help Menu Cannot Be Restored to Default Menu in Excel

 Last reviewed: November 2, 1994
Article ID: Q71724

SUMMARY

After deleting a default menu option from its menu bar, Microsoft Excel 3.00 will allow you to replace the default menu option to its original position, using the ADD.MENU command. However, removing the Help menu and then attempting to restore it with the ADD.MENU command results in a macro execution error. All other menus can be restored successfully.

MORE INFORMATION

Steps to Reproduce Problem

  1. Enter the following text onto a macro sheet:

    A1: Macro_Error A2: =DELETE.MENU(1,"Help") A3: =ALERT("Help Menu has been deleted") A4: =ADD.MENU(1,"Help") A5: =RETURN()

  2. Select cell A1.

  3. From the Formula menu, choose Define Name.

  4. Select the Command option and choose OK.

  5. Run the macro. "Macro Error at cell..." results.

Solution

The only way to restore the Help menu is to exit and restart the Excel program.

REFERENCES

"Microsoft Excel User's Guide," version 3.0, page 649

KBCategory: kbother
KBSubcategory:

Additional reference words: noupd

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 2, 1994
© 1998 Microsoft Corporation. All rights reserved. Terms of Use.