• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 358
  • Last Modified:

Maximized View Upon Opening Excel 2010

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
judico
Asked:
judico
  • 5
  • 3
1 Solution
 
Anne TroyEast Coast ManagerCommented:
Try right-clicking the Excel icon you use to launch Excel.
Choose Properties.
In the Run dropdown, choose Maximized.
0
 
judicoAuthor Commented:
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
 
Anne TroyEast Coast ManagerCommented:
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
Take Control of Web Hosting For Your Clients

As a web developer or IT admin, successfully managing multiple client accounts can be challenging. In this webinar we will look at the tools provided by Media Temple and Plesk to make managing your clients’ hosting easier.

 
judicoAuthor Commented:
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
 
Anne TroyEast Coast ManagerCommented:
Well, if safe mode did it, then you don't need to find the xlsb. You may not have one.
0
 
judicoAuthor Commented:
It still however is minimized when opening it normally.
0
 
judicoAuthor Commented:
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
 
judicoAuthor Commented:
I guess that's the best that can be done with the current version of Excel.
0

Featured Post

Get your problem seen by more experts

Be seen. Boost your question’s priority for more expert views and faster solutions

  • 5
  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now