[Last Call] Learn how to a build a cloud-first strategyRegister Now

x
?
Solved

Maximized View Upon Opening Excel 2010

Posted on 2014-02-20
8
Medium Priority
?
349 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
ID: 39875487
Try right-clicking the Excel icon you use to launch Excel.
Choose Properties.
In the Run dropdown, choose Maximized.
0
 

Author Comment

by:judico
ID: 39875606
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 300 total points
ID: 39875665
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
Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

 

Author Comment

by:judico
ID: 39875690
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
 
LVL 22

Expert Comment

by:Dreamboat
ID: 39875701
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
ID: 39875777
It still however is minimized when opening it normally.
0
 

Author Comment

by:judico
ID: 39875834
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
ID: 39876889
I guess that's the best that can be done with the current version of Excel.
0

Featured Post

How to Use the Help Bell

Need to boost the visibility of your question for solutions? Use the Experts Exchange Help Bell to confirm priority levels and contact subject-matter experts for question attention.  Check out this how-to article for more information.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

When you see single cell contains number and text, and you have to get any date out of it seems like cracking our heads.
Windows Explorer let you handle zip folders nearly as any other folder: Copy, move, change, and delete, etc. In VBA you can also handle normal files and folders, but zip folders takes a little more - and that you'll find here.
This Micro Tutorial will demonstrate on a Mac how to change the sort order for chart legend values and decrpyt the intimidating chart menu.
This Micro Tutorial will demonstrate in Google Sheets how to use the HYPERLINK function to create live links inside your spreadsheet.

825 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