Suspending MAcros

  • Thread starter Thread starter Kaval
  • Start date Start date
K

Kaval

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
 
Application.EnableEvents = False
' code that causes change to fire again
Application.EnableEvents = True
End sub
 
Back
Top