Minimizing Excel from a Macro

C

Craig

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
 
P

pauluk

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
 
Top