Maximize Excel

[ianripping]

When I open an excel document from a local webpage, the document open
up in a normal window, not maximized.

I tried inputing this code into the workbook module: -

Private Sub Workbook_Open()

Application.WindowState = xlMaximized
End Sub


But it was still opening in a normal window.
Am I doing anythign wrong

 

[Ulrik Gustafsson]

Hi

Try this instead in your Workbook_Open procedure:
ActiveWindow.WindowState = xlMaximized

The Excel document window will be maximized when you open the workbook. I
think this will do the trick.

HTH
/Ulrik