How to run VBA code at low priority?
 

Hi Excel Gurus,

I have a Excel VBA code which freezes my computer when it runs. The entire
code takes about 5 minutes to finish processing the data.

Is it possible to make it run at low priority so that my computer does not
freeze and I could still do some work?

How to run VBA code at low priority?
 

Sing,

No, you cannot do that with Excel.

HTH,
Bernie
MS Excel MVP


"Sing" wrote in message ...
Hi Excel Gurus,

I have a Excel VBA code which freezes my computer when it runs. The entire
code takes about 5 minutes to finish processing the data.

Is it possible to make it run at low priority so that my computer does not
freeze and I could still do some work?

How to run VBA code at low priority?
 

You could try setting the priority of the Excel process to "low".

http://www.microsoft.com/technet/scr...5/hey0516.mspx

Tim


"Sing" wrote in message
...
Hi Excel Gurus,

I have a Excel VBA code which freezes my computer when it runs. The entire
code takes about 5 minutes to finish processing the data.

Is it possible to make it run at low priority so that my computer does not
freeze and I could still do some work?