XL2000: "Name cannot resemble a reference." Error When Changing Reference Style Setting

Symptoms

When you change the reference style setting in Microsoft Excel, you may receive the following error message:

Name cannot resemble a reference.

Old name: macro name

New name:

NOTE: To change the reference style, use the R1C1 reference style check box on the General tab of the Options dialog box.

This behavior may occur when the following conditions are true:

To work around this behavior and change the reference style setting, follow these steps:

On the File menu, click Close. Save changes to your workbook if necessary.
On the File menu, click New.
On the Tools menu, click Options.
On the General tab, change the R1C1 reference style check box as appropriate. Click OK.
Reopen the original workbook.