Excel 4.0 Macros

[James Weaver]

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...any ideas anyone?!

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

 

[Jan Karel Pieterse]

Hi,

In Excel 97, when your workbook contains any objects with
a (normal) VBA macro attached to it, you can get the XL4
macro warning, even though you yourself haven't used any
XL4 macro at all.

Does the XL97 crash with macros disabled?

If not, hold the shift key whilst opening, enable macros
and step through your code to see what makes XL97 crash.

Regards,

Jan Karel Pieterse
Excel TA/MVP