Minimize Excel When Running a Macro

  • Thread starter Thread starter Paul Vovk
  • Start date Start date
P

Paul Vovk

Seems like this is a simple thing, but I can't seem to get
it. I want Excel to run minimized when the macro (VBA
code) runs. A separate script starts Excel and this macro.
The macro runs and then shuts down Excel. This is done
once per day. I need the macro to first minimize Excel so
it doesn't show up on the screen while the macro is
running as it takes ~10 minutes to run.
 
This is how to minimize the app

application.windowstate=xlminimized

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
 
ActiveWindow.WindowState = xlMinimized
UserForm1.Show

Double click the ThisWorkbook and copy the code above
 
Back
Top