I am not 100% sure if this will work for you or not but in the task manager
you can set the priority of the processes that are running. Open the Task
manager - Select the Processes tab - Right Click on Excel - Select Set
Priority and lower the priority from normal to ??? This tells the OS what
priority to give each program when it requests CPU time. I think that might
work for you...
--
HTH...

Jim Thomlinson


"Bill Martin" wrote:

I'm not sure if this is a VBA question, an Excel question, or an XP
question, but is there a way to limit how much CPU Excel burns?

I've written a macro that will endlessly run a Monte Carlo solution.
Normally I run it overnight and all is well. Sometimes however I run it
during the day, particularly if I'm tinkering with the code and want to run
it in the background to watch how it performs. When I do this it pegs CPU
usage at 100% and makes everything else on the machine painfully sluggish.

Is there some way to cut back on how much CPU Excel consumes? Ideally I'd
like my VBA routine to periodically sample CPU usage and adjust what Excel
consumes. Alternatively, is there someway I can manually adjust it?

Thanks.

Bill