View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Bob Phillips[_6_] Bob Phillips[_6_] is offline
external usenet poster
 
Posts: 11,272
Default Halt all code while macro runs

What exactly do you mean, Excel will only execute one thread at a time so it
does.

If you mean you want to stop Excel's events firing, worksheet events, set

Application.EnableEvents = false

and reset at the end.

--
HTH

Bob Phillips

"TimT" wrote in message
...
Is there a way to halt all other code or vba from running while a certain
macro runs?