MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Maximized View in Open

February 06, 2002 - by Juan Pablo Gonzalez

Jen asks:

How can I make sure Excel opens my file maximized? I need this for visibility purposes.

To make sure of this, right click in the little workbook (Next to File menu), and choose, View Code.

You should see this, and the cursor standing between those lines.

Private Sub Workbook_Open()

End Sub

Put this code there.

Private Sub Workbook_Open()
	Application.WindowState =xlMaximized
End Sub


Extracted from Message Board.