Solved

Maximized View Upon Opening Excel 2010

Posted on 2014-02-20
8
317 Views
Last Modified: 2014-02-21
Excel.exe I have, opens in minimized view as default. If then a Book1.xlms is saved with the code:

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

in Sheet1, the new default becomes Maximized when opening it, as desired.

Is there a way to open Excel.exe itself Maximized as default without saving it as a separate workbook?
0
Comment
Question by:judico
  • 5
  • 3
8 Comments
 
LVL 22

Expert Comment

by:Dreamboat
Comment Utility
Try right-clicking the Excel icon you use to launch Excel.
Choose Properties.
In the Run dropdown, choose Maximized.
0
 

Author Comment

by:judico
Comment Utility
I did that but Excel.exe still doesn't open Maximized. Even when I maximize it when open and then close it, the followup opening still isn't maximized.
0
 
LVL 22

Accepted Solution

by:
Dreamboat earned 100 total points
Comment Utility
Try opening in safe mode. Hold the shift key while you open it. If that doesn't work, see if you can find personal.xlsb file in (I think) C:\Users\Default\AppData\Roaming\Microsoft and move it. Must close Excel first.
0
 

Author Comment

by:judico
Comment Utility
Safe mode did it. I'm on a MacBook Pro, so i had to depress simultaneously fn-control-shift. After double clicking a message appears asking if I'd like to open the program in safe mode. I couldn't find the file personal.xlsb, however. First, there's no folder C:\Users ... Tried to search for it but no such file was found.
0
Do You Know the 4 Main Threat Actor Types?

Do you know the main threat actor types? Most attackers fall into one of four categories, each with their own favored tactics, techniques, and procedures.

 
LVL 22

Expert Comment

by:Dreamboat
Comment Utility
Well, if safe mode did it, then you don't need to find the xlsb. You may not have one.
0
 

Author Comment

by:judico
Comment Utility
It still however is minimized when opening it normally.
0
 

Author Comment

by:judico
Comment Utility
Now, here's a workaround. Excel.exe still opens minimized but then I extend it manually to look as if it's maximized. Upon closing and then reopening it, the new size is retained. I know that's not the solution sought for but may be used temporarily until we find the real one.
0
 

Author Closing Comment

by:judico
Comment Utility
I guess that's the best that can be done with the current version of Excel.
0

Featured Post

IT, Stop Being Called Into Every Meeting

Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

Join & Write a Comment

Improved? Move/Copy Add-in Replacement - How to avoid the annoying, “A formula or sheet you want to move or copy contains the name XXX, which already exists on the destination worksheet.” David Miller (dlmille)  It was one of those days… I wa…
This article will guide you to convert a grid from a picture into Excel format using Microsoft OneNote and no other 3rd party application.
The viewer will learn how to simulate a series of sales calls dependent on a single skill level and learn how to simulate a series of sales calls dependent on two skill levels. Simulating Independent Sales Calls: Enter .75 into cell C2 – “skill leve…
This Micro Tutorial will demonstrate the scrolling table in Microsoft Excel using the INDEX function.

771 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

11 Experts available now in Live!

Get 1:1 Help Now