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?