Maximize Excel
 

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

--
Message posted from http://www.ExcelForum.com

Maximize Excel
 

Hi

Try this instead in your Workbook_Open procedu
ActiveWindow.WindowState = xlMaximized

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

HTH
/Ulrik


"ianripping " wrote in message
...
When I open an excel document from a local webpage, the document opens
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?


---
Message posted from http://www.ExcelForum.com/