Microsoft KB Archive/72104

{| = RENAME.COMMAND Does Not Retain Changes with Certain Menu Items =
 * width="100%"|

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
  Enter the following in a macro sheet: A1: =RENAME.COMMAND(1,&quot;Window&quot;,&quot;Arrange...&quot;,&quot;Skew&quot;) A2: =RETURN Note: In Excel 3.0 use: A1: =RENAME.COMMAND(1,&quot;Window&quot;,&quot;Arrange All&quot;,&quot;Skew&quot;)  Select cell A1 and choose Define Name from the Formula menu. Type anything in the Name box. Select the Command button and choose OK. Run the macro. Select the Window menu to ensure that Arrange... (Arrange All in Excel 3.0) has changed to Skew.  Choose any other item from the Window menu or activate another worksheet. Skew has changed back to Arrange... (Arrange All in Excel 3.0). 