| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Minimize Excel When Running a Macro
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. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Minimize Excel When Running a Macro
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) "Paul Vovk" wrote in message ... 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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Running a Macro automatically from Excel | Excel Worksheet Functions | |||
| how do i minimize/maximize a workbook from vba? I want to minimize it durring processing to speed things up a bit | Excel Worksheet Functions | |||
| Running a excel macro from VB6 | Excel Programming | |||
| Launch Macro in Access via Macro running in Excel??? | Excel Programming | |||
| Running Excel Macro from VB6 | Excel Programming | |||
Linear Mode
