Extracted from MrExcel.com Message Board

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.

Application.WindowState =xlMaximized