Excel won't open maximized

The personal macro workbook is hidden by default, choose View, Unhide.

Note: you do not need to view the spreadsheet to be able to modify the macros, just press Alt+F11, you will see the file displayed on the top left as Personal, expand its Module folder and double-click any Modules

If this answer solves your problem, please check, Mark as Answered. If this answer helps, please click the Vote as Helpful button. Cheers Shane Devenshire

One, the personal notebook is loaded automatically by Excel, without any coding required (it autoloads the personal.xls in C:\Documents and Settings[username]\Application Data\Microsoft\Excel\XLSTART

 Two, because you never had to do that with previous versions;

Three, because sometimes you do want to load non-maximized and it was easier to have a couple of icons to control this (one for nomram and one for maximized) than the have to hard code it intop the personal file.

sh

Yes, it's not the fact that it's hidden that's at issue. I realize a workaround is to make an auto-run macro in the auto-load speadsheet so that it opens maximized everytime regardless of whether you try to start it normal or maximized.

 IN fact, it's only when the file is hidden that Excel won't load maximized. If it's saved unhidden, then excel will load maxmized (or however icon prperties are set) -- then, if you hide the perosnal spreadsheet and clsoe Excel, thereafter it won't load maximized.

Another workaround it to manualyl maximize the window after Excell 2010 loads. IT was much better when you could control this by the property setting in the icon used to sart the program. IN this re Excel 2010 doesn't hold to the standards very well.

It sure was easier to get this simple thing the way you wanted it in priior verisons. I'm still hoping SP1 corrects this deficit in the design.

sh

It appears you used two different icons to start Excel, one that opened it maximized, the other did not.  If so, I suspect, you were using a command line switch to control how Excel opened.  AFAIK, Excel 2007 and 2010 removed many if not all of the switches.

You could use a VBS script to accomplish the same.

Save the below as, say, XLmax.vbs

Set WshShell = WScript.CreateObject("WScript.Shell")

wshshell.run """c:\program files (x86)\Microsoft Office\Office14\Excel.exe""",3

Save the below as, say, XLreg.vbs

Set WshShell = WScript.CreateObject("WScript.Shell")

wshshell.run """c:\program files (x86)\Microsoft Office\Office14\Excel.exe""",1

Double-click the first to open Excel with its window maximized, the second to open it with 'normal' focus.

You can experiment with the last argument.  See

Run Method (Windows Script Host)

http://msdn.microsoft.com/en-us/library/d5fk67ky%28VS.85%29.aspx

Yes, it's not the fact that it's hidden that's at issue. I realize a workaround is to make an auto-run macro in the auto-load speadsheet so that it opens maximized everytime regardless of whether you try to start it normal or maximized.

 

Another workaround it to manualyl maximize the window after Excell 2010 loads. IT was much better when you could control this by the property setting in the icon used to sart the program. IN this re Excel 2010 doesn't hold to the standards very well.

It sure was easier to get this simple thing the way you wanted it in priior verisons. I'm still hoping SP1 corrects this deficit in the design.

---

sh

Tushar Mehta (Technology and Operations Consulting)

www.tushar-mehta.com (Excel and PowerPoint add-ins and tutorials)

Microsoft MVP Excel 2000-Present

No, not a command line switch, jsut the propert setting for the icon -- right click any icon, select Propoerties,  and you'll see a setting called "Run" which allows yo to set for Maximized, NOrmal, of Minimized. It works for most programs, but not Excel 2010.

sh