Thread: Maximize Excel
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Ulrik Gustafsson Ulrik Gustafsson is offline
external usenet poster
 
Posts: 9
Default 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/