Is there an old pre-97 way of making a workbook an addin?

Yes. Excel 5 and 95 add-ins were created via Make Add-in on the Tools menu.
There was no VBE and no IsAddin property. Excel 4 macros were put on Excel 4
macro sheets. VB macros with on module sheets.

That said, this file cannot be such an add-in because (1) you said it was
created in Excel 97 and (2) you 'see' something. Add-ins are not visible in
Excel.

If you send it to me I can probably tell you why you're getting the XL4
macro warning.
--
Jim
"Chris Wilkinson" wrote in
message ...
| 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