How to open Excel workbook in full size window

[Guest]

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?

 

[Guest]

Eunice,

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.

 

[Guest]

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.

Thanks for your response.

 

[Guest]

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

 

[Guest]

Ok - 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.

 

[Dave Peterson]

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

 

[Guest]

Thanks it worked great.

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

 

[Guest]

Thanks - one other question if someone wanted the spreadsheet maximum in side
a
Restored down window, could that be done. They are transferring data from
another pdf image and need to be able to see both on the screen.

 

[Guest]

Replace this line:

Application.WindowState = xlMaximized 'maximize the application window

with this:

Application.WindowState = xlNormal 'Restore the application window size