ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   I want to launch Excel 2007 in Maximized state every time (https://www.excelbanter.com/excel-discussion-misc-queries/197774-i-want-launch-excel-2007-maximized-state-every-time.html)

Karen B

I want to launch Excel 2007 in Maximized state every time
 
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 want to launch Excel 2007 in Maximized state every time
 
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


Karen B wrote:

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


All times are GMT +1. The time now is 05:44 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com