help with macro in Excel 2007

  • Thread starter Thread starter Michelle
  • Start date Start date
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?
 
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?
 
Back
Top