I have developed a model in Excel 97 that contains a
number of macros (including an Auto_Open macro) and a
number of array formulae. For some users, the Model
crashes on opening. This problem can be solved by uisng
Excel 2000 but I want to get to the root of the problem.
I think it is either due to the macros or the array
formulae.

If you try to Disable macros on opening the file, you get
the following message:

"The workbook contains a type of macro (Microsoft Excel
version 4.0 macros) that cannot be disabled. There may be
viruses in these macros."

I am wondering whether it is the Excel 4.0 macros that are
causing the file to crash on re-opening for some users.

IS THERE ANY WAY TO FIND OUT (i) WHICH PARTS OF THE MACROS
ARE RECOGNISED AS EXCEL 4.0 MACROS AND (ii) HOW TO CONVERT
THESE MACROS TO EXCEL 97?

Thanks,
James