help with macro in Excel 2007
 

I have a query from a user who, in Excel 2003, would run a macro that
involved going to a worksheet. If the worksheet name was changed, the macro
still worked.

In Excel 2007, if the worksheet name is changed, the macro doesn't work.
Can anyone help with this?
--
Michelle

help with macro in Excel 2007
 

On Feb 9, 5:54*pm, Michelle
wrote:
I have a query from a user who, in Excel 2003, would run a macro that
involved going to a worksheet. *If the worksheet name was changed, the macro
still worked.

In Excel 2007, if the worksheet name is changed, the macro doesn't work. *
Can anyone help with this?
--
Michelle

What does the original code look like?