| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Disable Macro
Is there a way to temporarily disable a macro while
running another macro? I have a macro that is activated on Worksheet change. I'd like to disable this while the other macro is running. Thank you for your help. Mark. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Disable Macro
Mark,
You may want to investigate Application.EnableEvents = False Rob "Mark" wrote in message ... Is there a way to temporarily disable a macro while running another macro? I have a macro that is activated on Worksheet change. I'd like to disable this while the other macro is running. Thank you for your help. Mark. |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Disable Macro
Application.enableEvents = False
' Application.EnableEvents = True will stop events for Excel objects from running. -- Regards, Tom Ogilvy Mark wrote in message ... Is there a way to temporarily disable a macro while running another macro? I have a macro that is activated on Worksheet change. I'd like to disable this while the other macro is running. Thank you for your help. Mark. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Disable running of SelectionChange macro when in another macro? | Excel Discussion (Misc queries) | |||
| Disable Esc-key - macro | Excel Discussion (Misc queries) | |||
| How to disable the Macro? | Excel Discussion (Misc queries) | |||
| disable user running macro from Tools Macro | Excel Discussion (Misc queries) | |||
| Disable Macro at open by an external macro | Excel Programming | |||
Linear Mode
