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

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" wrote in message
...
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

Thanks Kevin.

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

James
-----Original Message-----
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" wrote in message
...
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


.

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


"James Weaver" wrote in message
...
Thanks Kevin.

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

James
-----Original Message-----
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" wrote in message
...
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


.