Sca2003 Read This First wrote:
I still can't see what is causing my problem on startup. Could it be the custom views?

Can you not step through the code to find out where the problem is coming from?
At least put a Stop statement at the start of Auto_Open and then if you get the error
before the Stop you know it is some workbook other than yours that is being loaded and
reporting the error. From the Stop statement you can step on to see which statement
gives the error.

If you don't need some statements in Excel 97 then

If Val(Application.Version)<8 Then
'.... statements for 95 and below
End If

Bill Manville
MVP - Microsoft Excel, Oxford, England
No email replies please - reply in newsgroup