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.

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

 

[Kevin Stecyk]

James,

XL4 macros are written on XLM sheets. They look like regular spreadsheets,
except that the default columns are wider, and if you enter a formula into
an XLM sheet, the formula remains. If you wrote "=4+5", the cells would not
display 9.

Have a look at all the sheets contained in the workbook for an XLM sheet.

I was once reasonably proficient in XLM, but am not any longer.

As far as converting, there is no way to convert, other than to rewrite. In
most cases, the XLM code should continue to work fine and without
difficulty.

I hope others jump in and provide additional comments.

Best regards,
kevin

 

[James Weaver]

Thanks Kevin.

How do I find these sheets or know that they might exist?!

James

 

[Kevin Stecyk]

James,

Sorry, didn't see your message. My mistake.

If you are still curious, you just have to cycle through your sheets and
look for the XLM sheets.

Regards,
Kevin