Maximize on open

  • Thread starter Thread starter Marty
  • Start date Start date
M

Marty

Hello,

How do you ensure that when you open an Excel file it will
open maximized and not minimized?

Thanks
 
Marty said:
Hello,

How do you ensure that when you open an Excel file it will
open maximized and not minimized?

Thanks
Click to expand...

Close Excel Maximised and this is how it will open next time.
 
You could use a macro:

In a general module:

Option Explicit
Sub Auto_Open()
ActiveWindow.WindowState = xlMaximized
Application.WindowState = xlMaximized
End Sub


I recorded a macro when I did it by hand. (And I maximized both the application
and the activewindow.)

(You could stick it under the ThisWorkbook module, too--in the workbook_open
event.)

If you're new to macros, you may want to read David McRitchie's intro at:
http://www.mvps.org/dmcritchie/excel/getstarted.htm
 
Marty,

This will maximize either the document (workbook) window or application
(Excel) window, or both, depending on which lines you include:

Private Sub Workbook_Open()
Application.WindowState = xlMaximized
ActiveWindow.WindowState = xlMaximized
End Sub

The user will have to have allowed macros at the macro prompt when opened.
 
Dave,

Hmmm. When I made my reply, yours wasn't there. Yet mine was over three
hours later. But sometimes posts show up in minutes. Hmmm.
 
I'm kind'a glad they matched <g>.



Earl said:
Dave,

Hmmm. When I made my reply, yours wasn't there. Yet mine was over three
hours later. But sometimes posts show up in minutes. Hmmm.
Click to expand...
 
The only way I know this is:

Set the application to maximised, then hold the 'Ctrl' key
down and exit the app via the 'x' in the corner and it will
remember the state it was in as you closed it the next
time its opened...

seeya ste
 
Back
Top