Solved

Maximized View Upon Opening Excel 2010

Posted on 2014-02-20
8
332 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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 100 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
Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 

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

On Demand Webinar: Networking for the Cloud Era

Ready to improve network connectivity? Watch this webinar to learn how SD-WANs and a one-click instant connect tool can boost provisions, deployment, and management of your cloud connection.

Question has a verified solution.

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

How to get Spreadsheet Compare 2016 working with the 64 bit version of Office 2016
This article describes a serious pitfall that can happen when deleting shapes using VBA.
This Micro Tutorial demonstrates how to create Excel charts: column, area, line, bar, and scatter charts. Formatting tips are provided as well.
Excel styles will make formatting consistent and let you apply and change formatting faster. In this tutorial, you'll learn how to use Excel's built-in styles, how to modify styles, and how to create your own. You'll also learn how to use your custo…

690 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