How to fullscreen Excel Worksheet

[Calverta]

Some time ago Excel stopped opening my scheduled worksheets in a full size window. The sheets function otherwise as expected. It is just an annoyance to have to enlarge the window after the file opens automatically. There are three of them that start every morning. I have not been able to locate how to change it myself. Is there a way to make sure the Excel sheets always open in a full size window.

[Alejandro80]

Excel "remembers" that last window size it was on.
1. Start Excel
2. Maximize the main application window and the workbook window that Excel
creates automatically.
3. Once you have thew windows maximized the way you want them, Exit Excel.

[Calverta]

This did not help. I did as you stated in your response but the application is still opening in a small window and the workbook is opening in a small window.

[Kaufman]

I'm assuming you have write access to these workbooks and you can add macros. If so, then you can add this to the workbook code module to maximize the windows when the workbook is opened:

Private Sub Workbook_Open()
Application.WindowState = xlMaximized 'maximize the application window
ActiveWindow.WindowState = xlMaximized 'maximize the workbook window
End Sub

[little-Jacqueline]

Ok I am working on the macro - what am I doing wrong. I have added a module with

Sub Maximum_Open()
'
' Maximum Macro
' Macro recorded 2/23/2007 by mrpaulo
'

'
Private Sub Workbook_Open()
Application.WindowState = xlMaximized 'maximize the application window
ActiveWindow.WindowState = xlMaximized 'maximize the workbook window

End Sub

and I have set up a sheet that says the following:

Private Sub Maximum_Open()
Call Maximum_Form
End Sub

late in the day I may be loosing it.

[Liliana]

There are a couple of ways to have a procedure run each time excel opens the workbook. The first way is to put the procedure in a General module (not behind a
worksheet, not behind ThisWorkbook).

Name that procedure
Sub Auto_Open()
(and don't change the name)

Sub Auto_Open()
Application.WindowState = xlMaximized 'maximize the application window
ActiveWindow.WindowState = xlMaximized 'maximize the workbook window
End Sub

The second way is to use the Workbook_Open event. This procedure goes behind the ThisWorkbook module : Private Sub Workbook_Open(). You can't change the name of this one, either (or excel won't find either of them) :

 Private Sub Workbook_Open()
Application.WindowState = xlMaximized 'maximize the application window
ActiveWindow.WindowState = xlMaximized 'maximize the workbook window
End Sub