View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Chip Pearson Chip Pearson is offline
external usenet poster
 
Posts: 7,247
Default programmatically changing priority of running excel macro at runti

You can't change the priority of Excel's macros.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


"Bing" wrote in message
...
Hi again,

Is it possible/how to change the priority level of a running
macro within a
macro itself. For example, when doing file i/o which is
intensive i would
like to lower it's priority so that it doesn't hog cpu. I
won't have to
worry about the macro holding the file lock for too long
because this will be
the only process accessing the file.

Thanks again.
Bing