Excel -- minimized on startup

Posted on 2011-09-12
Last Modified: 2012-05-12
How can I get option #1 to work
without having it minimized ?

This works on all my other PCs.

Option #1
 1. Double click on "test.xls"
 2. Excel program opens, but is minimized

Option #2
 1. Open Excel program
 2. Then double click on "test.xls"
 3. File opens maximized
Question by:finance_teacher
  • 2

Accepted Solution

Pabilio earned 250 total points
ID: 36526014
Hi Finance teacher

Put this code in the thisworkbook module:

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

Hope it is what you are looking


Author Comment

ID: 36526058
I want the EXCEL files to always be Maximized, not minimized (without making users open Excel program first)

What other solution do you have ?

Expert Comment

ID: 36526100
Then I'm not sure if I understood your question...
If you want the files to open Maximized the use:

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

But I don't think it is what you are looking for...

LVL 23

Assisted Solution

Michael74 earned 250 total points
ID: 36527204
On the shortcut to open the excel program itself

Right click and select Properties.
About halfway down the dialogue box look for 'Run'.
From the drop down choose 'Maximised' and then click 'Apply'.


Featured Post

How your wiki can always stay up-to-date

Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
- Increase transparency
- Onboard new hires faster
- Access from mobile/offline

Join & Write a Comment

Workbook link problems after copying tabs to a new workbook? David Miller (dlmille) Intro Have you either copied sheets to a new workbook, and after having saved and opened that workbook, you find that there are links back to the original sou…
Entering a date in Microsoft Access can be tricky. A typo can cause month and day to be shuffled, entering the day only causes an error, as does entering, say, day 31 in June. This article shows how an inputmask supported by code can help the user a…
The viewer will learn how to create two correlated normally distributed random variables in Excel, use a normal distribution to simulate the return on different levels of investment in each of the two funds over a period of ten years, and, create a …
This Micro Tutorial will demonstrate the scrolling table in Microsoft Excel using the INDEX function.

706 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

12 Experts available now in Live!

Get 1:1 Help Now