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

Note

Extracted from MrExcel.com Message Board.