RENAME.COMMAND Does Not Retain Changes with Certain Menu Items

Last reviewed: November 3, 1994
Article ID: Q72104
The information in this article applies to:
  • Microsoft Excel for Windows, versions 3.0, 4.0

SUMMARY

The RENAME.COMMAND() macro function in Microsoft Excel allows you to rename options on your worksheet menus. However, when certain items are renamed, they will not retain their new names if another document is activated or, in some cases, if another option is chosen from a menu.

STATUS

Microsoft Excel has confirmed this to be a problem in the versions of Microsoft Excel listed at the beginning of this article. This problem was corrected Microsoft Excel version 5.0.

NOTE: In Microsoft Excel 5.0, certain menu names do not retain their new names by design. For example, the Undo and Repeat commands will change relative to the current action.

MORE INFORMATION

The following menu commands will not retain their new names.

Excel 4.0 Menu Items

Menu            Command

File            Save As
                Record Macro... (Nil menu bar)

Edit            Insert
                Undo
                Repeat
                Clear

Data            Find

Options         Set Print Area
                Set Print Titles
                Set Page Break
                Protect Document

Macro           Record
                Relative Record

Window          Arrange
                Freeze Panes

Chart           Add Arrow
                Add Legend
                Add Overlay
                Protect Document

Excel 3.0 Menu Items

Menu            Option
----            ------

File            Save As
                Record (Nil menu bar)

Edit            Insert
                Undo
                Repeat
                Clear

Data            Find

Options         Set Print Area
                Set Print Titles
                Protect Document
                Set Page Break
                Freeze Panes

Macro           Record
                Relative Record

Window          Arrange All

Chart           Add Arrow
                Add Legend
                Add Overlay
                Protect Document

Steps to Reproduce Problem

  1. Enter the following in a macro sheet:

          A1: =RENAME.COMMAND(1,"Window","Arrange...","Skew")
          A2: =RETURN()
    

    Note: In Excel 3.0 use:

          A1: =RENAME.COMMAND(1,"Window","Arrange All","Skew")
    

  2. Select cell A1 and choose Define Name from the Formula menu. Type anything in the Name box. Select the Command button and choose OK.

  3. Run the macro.

  4. Select the Window menu to ensure that Arrange... (Arrange All in Excel 3.0) has changed to Skew.

  5. Choose any other item from the Window menu or activate another worksheet.

    Skew has changed back to Arrange... (Arrange All in Excel 3.0).

REFERENCES

"Function Reference," version 4.0, page 355 "Function Reference," version 3.0, page 195


KBCategory: kbusage
KBSubcategory:

Additional reference words: 3.00 4.00


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