help with macros in Excel 2007
 

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
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services, Inc.
http://PeltierTech.com/WordPress/
_______


"Michelle" wrote in message
...
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?
--
Michelle