I want to launch Excel 2007 in Maximized state every time

[Karen B]

In all previous versions of Excel, you could specify that when you open the
program, the worksheet would open maximized on the screen. This new Excel
2007 doesn't always do that. Often when I open it, the program displays
tiled in the center of my screen. If I then maximize it and close it, and
then open it again - it will open maximized. Does anyone know how I can STOP
it from opening in a reduced size - and always open maximized to my screen?

 

[Dave Peterson]

I think your memory is failing <bg>.

xl2003 (and previous versions) remember the window state from when I previously
closed excel.

But you could use a macro in a workbook in your XLStart folder that maximizes
the screen:

Option Explicit
Sub auto_open()
Application.WindowState = xlMaximized
ThisWorkbook.Close savechanges:=False
End Sub