help with macros in Excel 2007

[Michelle]

I have had an enquiry from a user. In Excel 2003 she could create and run a
macro that included going to a specific worksheet. If the worksheet name
changed after the macro was created, the macro still worked.

In Excel 2007, if the worksheet name is changed after the macro is created,
the macro does not work?

Any suggestions?

 

[Jon Peltier]

If the worksheet name changed after the macro was created, the macro still

worked.

I don't believe this. The macro would be hard coded with something like

Sheets("My Sheet").Activate

and changing the sheet name would produce an error in this command. This is
true in Excel 2007 or any previous version.

- Jon