RENAME.COMMAND Does Not Retain Changes with Certain Menu Items

• 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