Maximized View in Open
February 06, 2002 - by Juan Pablo Gonzalez
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 MrExcel.com Message Board.