hi,

I have inherited a spreadsheet that was written in 'Excel 97 but when I try
to disable macros it says there are Excel 4 macros that cannot be disabled.
Where would I find them? There are VBA modules but I cannot see any
Application.ExecuteExcel4Macro statements. How are EXcel 4 Macros executed?

Also, the spreadsheets opens another workbook by using a defined name called
Auto_open_logon which in turn calls a procedure in the other workbook. (I had
never seen this before). The other workbook looks and behaves exactly like an
Addin except that IsAddin is FALSE. It has one sheet which you cannot see,
although its visible property is set to xlVisible. If you try to change its
visible propery, you get a runtime error. (it is not protected, I
checked).This workbook contains only forms and modules and an unviewable
worksheet. Am I missing something? Is there an old pre-97 way of making a
workbook an addin? Or is it a Excel 4 macro workbook - if that is possible?
It is driving me mad trying to work out why this workbook is behaving the way
it does.

Can anyone help me?

Thanks,
Chris