| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Suspending MAcros
I am using a Worksheet_Change macro to update several
cells when a change is made in a specific range. When the macro changes the other cells it then starts the Worksheet_Change routine again and I end up with an endless loop. Is there an easy way to temporarily suspend the Worksheet_Change macro while cells are updated and then re-enable? Kaval |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Suspending MAcros
Application.EnableEvents = False
' code that causes change to fire again Application.EnableEvents = True End sub -- Regards, Tom Ogilvy "Kaval" wrote in message ... I am using a Worksheet_Change macro to update several cells when a change is made in a specific range. When the macro changes the other cells it then starts the Worksheet_Change routine again and I end up with an endless loop. Is there an easy way to temporarily suspend the Worksheet_Change macro while cells are updated and then re-enable? Kaval |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| convert lotus 123w macros to excel macros | Excel Programming | |||
| convert lotus 123w macros to excel macros | Excel Programming | |||
| suspending-interacting-resuming | Excel Programming | |||
| Macro Size Limit / open macros with macros? | Excel Programming | |||
| Suppress the Disable Macros / Enable Macros Dialog | Excel Programming | |||
Hybrid Mode
