help with macros in Excel 2007

  • Thread starter Thread starter Michelle
  • Start date Start date
M

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?
 
If the worksheet name changed after the macro was created, the macro still
worked.
Click to expand...

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
 
Back
Top