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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

help with macros in Excel 2007 1
VBA Excel - Select a value from one cell in Excel to update a SQL table 1
Oops sent to wrong forum: Excel Macros 2
Excel 2007: Help creating a macro that will run Solver? 3
problem with macros and protections 5
How to find out the cause for Excel 2007 slower than Excel 2003? 4
Setting Scope of name ranges to particular worksheet 2
EXCEL 2007 Macro Security Being Ignored 9

Back
Top