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

Excel -- minimized on startup

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
  • 2
2 Solutions
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

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

What other solution do you have ?
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...

Michael FowlerSolutions ConsultantCommented:
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'.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Cloud Class® Course: SQL Server Core 2016

This course will introduce you to SQL Server Core 2016, as well as teach you about SSMS, data tools, installation, server configuration, using Management Studio, and writing and executing queries.

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