Minimizing Excel from a Macro
 

I have an app. which uses a macro to analyse huge amounts of dynamic data
until a certain condition is reached and this can take up to several hours
in certain cases.
Is there any way I can insert an insruction into the macro to minimize Excel
once the macro is running so as to allow me to do other things on the PC?

Many Thanks
Craig

Minimizing Excel from a Macro
 

if you add this to the start of the macro

Application.WindowState = xlMinimized

and then this to the end of the macro

Application.WindowState = xlNormal

It should minimize when the macro starts and then by adding the las
part it should max when the macro has ended

--
Message posted from http://www.ExcelForum.com