Maximize on open

M

Marty

Hello,

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

Thanks
 
P

Paul

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

Dave Peterson

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
 
E

Earl Kiosterud

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

Earl Kiosterud

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

Dave Peterson

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

ste mac

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
 
Top