help with macro in Excel 2007

M

Michelle

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?
 
C

CurlyDave

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?
Click to expand...

What does the original code look like?
 
Top