When I open a template in Excel 2000, I get the following warning message:

"This workbook contains a type of macro (Microsoft Excel version 4 macro)
that cannot be disabled. There may be viruses in these macros. If you are
sure this workbook is from a trusted source, click yes. Open the workbook?"

I've commented out all macro and other vba code and still get this message.
How can I determine what is causing it?

Thanks
Rut

Hi
you have to completely remove the modules. Just commenting out is not
sufficient

--
Regards
Frank Kabel
Frankfurt, Germany

rut wrote:
When I open a template in Excel 2000, I get the following warning
message:

"This workbook contains a type of macro (Microsoft Excel version 4
macro) that cannot be disabled. There may be viruses in these macros.
If you are sure this workbook is from a trusted source, click yes.
Open the workbook?"

I've commented out all macro and other vba code and still get this
message. How can I determine what is causing it?

Thanks
Rut

VB4 macros are on macro sheets - generally they're hidden.

Best thing to do is to copy the worksheets to a new workbook if you don't
need the code.



"rut" wrote:

When I open a template in Excel 2000, I get the following warning message:

"This workbook contains a type of macro (Microsoft Excel version 4 macro)
that cannot be disabled. There may be viruses in these macros. If you are
sure this workbook is from a trusted source, click yes. Open the workbook?"

I've commented out all macro and other vba code and still get this message.
How can I determine what is causing it?

Thanks
Rut