I have an old, very large macro, programmed using Excel Functions, which
exists in a .xlm sheet in Excel 2000. It has run successfully since 1993 and
ran successfully on Excel 2000 when I had an earlier version of Windows. I
reinstalled Office 2000 under Windows XP and the macro no longer runs,
producing a spurious error message. "Stepping through" the macro shows that
what is really happening is that the data references, intended to apply to
the .xls sheet, are being interpreted as references to the .xlm sheet, so
that cells in the .xlm sheet are being manipulated and deleted instead of the
correct cells in the .xls sheet.

I've tried using the "activate" function to point the macro to the .xls
sheet, but that does not change anything.

How do I now get the macro to process the .xls sheet instead of the .xlm
sheet?

I have a ton of old Excel 4 code that runs just fine under any Excel version
under any Windows version. Excel 4 code often operates on the active sheet.
Make sure when running your code that the worksheet is active. If you would
testing code by firing a macro while the macro sheet was active I could see
it having the effect you're seeing.

--
Jim
"John Mc" wrote in message
...
|I have an old, very large macro, programmed using Excel Functions, which
| exists in a .xlm sheet in Excel 2000. It has run successfully since 1993
and
| ran successfully on Excel 2000 when I had an earlier version of Windows. I
| reinstalled Office 2000 under Windows XP and the macro no longer runs,
| producing a spurious error message. "Stepping through" the macro shows
that
| what is really happening is that the data references, intended to apply to
| the .xls sheet, are being interpreted as references to the .xlm sheet, so
| that cells in the .xlm sheet are being manipulated and deleted instead of
the
| correct cells in the .xls sheet.
|
| I've tried using the "activate" function to point the macro to the .xls
| sheet, but that does not change anything.
|
| How do I now get the macro to process the .xls sheet instead of the .xlm
| sheet?
|
|