hi Peter,
the workbook is very large, so I'm not too sure how I 'm going to find the
named formulas. I did not realise that for an addin at least 1 sheet had to
visible even if it is not really visible. Do you know why the workbook looks
and behaves like an addin but the isaddin property is set to false. Jim Rech
thinks it may be be because it was created in a version prior to '97. If that
is true, how do I find the Excel 4 macros. I have read that they are on macro
sheets, but I cannot see any of them. But I don't know where to look.

Chris

"Peter T" wrote:

Another thought, do you have any Named formulas that include Excel4 macros.

Also, a workbook must always contain at least one visible sheet, even if
it's an addin or a hidden workbook. So indeed you wouldn't be able to change
the visible property of the sole sheet in the workbook. Is the workbook
hidden, like Personal.xls (main menu, Window Unhide).

Regards,
Peter T

"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

You may want to get Jan Karel Pieterse's (with Charles Williams and Matthew
Henson) Name Manager:

You can find it at:
NameManager.Zip from http://www.oaltd.co.uk/mvp

You may help you find any offending name.

And I think that Jan Karel Pieterse (or Harald Staff???) has posted that using
Goal seek that can give this warning, too.




Chris Wilkinson wrote:

hi Peter,
the workbook is very large, so I'm not too sure how I 'm going to find the
named formulas. I did not realise that for an addin at least 1 sheet had to
visible even if it is not really visible. Do you know why the workbook looks
and behaves like an addin but the isaddin property is set to false. Jim Rech
thinks it may be be because it was created in a version prior to '97. If that
is true, how do I find the Excel 4 macros. I have read that they are on macro
sheets, but I cannot see any of them. But I don't know where to look.

Chris

"Peter T" wrote:

Another thought, do you have any Named formulas that include Excel4 macros.

Also, a workbook must always contain at least one visible sheet, even if
it's an addin or a hidden workbook. So indeed you wouldn't be able to change
the visible property of the sole sheet in the workbook. Is the workbook
hidden, like Personal.xls (main menu, Window Unhide).

Regards,
Peter T

"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




--

Dave Peterson

Chris Wilkinson wrote...
the workbook is very large, so I'm not too sure how I 'm going to
find the named formulas. . . .

Create a new workbook, insert a general module in it, and add the
following macro to it.

Sub foo()
Dim n As Name
For Each n In ActiveWorkbook.Names
If n.Value Like "=*[-+*/^()]*" Then
MsgBox Title:=n.Name & IIf(n.Visible, "", " [hidden]"), _
prompt:=n.Value, Buttons:=vbOKOnly
End If
Next n
End Sub

Then switch to your problem workbook and run this macro. Or download
and install Jan Karel Pieterse's Name Manager add-in.