| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Halt all code while macro runs
Is there a way to halt all other code or vba from running while a certain
macro runs? |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Can you code a macro so it runs multiple times in the same workboo | Excel Discussion (Misc queries) | |||
| Code Halt - prevents reset of the AutomationSecurity level | Excel Programming | |||
| Code to halt a macro | Excel Programming | |||
| Code runs different in a commandbutton than a macro why? | Excel Programming | |||
Hybrid Mode
