I've seen a few posts that suggest that workbook_open and auto_open can have
timing trouble when you're opening the workbook.
This might not even be close to the problem/solution, but maybe you can try
this:
Private Sub Workbook_Open()
Application.OnTime Now, "Continue_Open"
End Sub
Then in a General module,
sub Continue_Open()
ActiveWindow.WindowState = xlMaximized
end sub
GermanExcel to Swedish wrote:
We have an Excel 2000 file, converted to Excel 97 which
has been produced in Germany. We will run the file in
Sweden, but on our Windows 2000 computer with Excel 97 it
doesn't work. We got the Run-time error on
Method "WindowState" of object "Window" failed.
Private Sub Workbook_Open()
ActiveWindow.WindowState = xlMaximized
Do we have some strainge configurations or what??
The file works on Windows XP with Excel 2003
Please help!
--
Dave Peterson