stopping a change event

[Cathy]

I have an event that fires off when a change occurrs in
the worksheet. The event changes values and colors of
cells. Each time the event changes something, it also
calls itself which results in an endless loop. Does
anyone know how I can stop the event from calling
itself?

Thanks
Cahty

 

[Frank Kabel]

Hi Cathy
At the beginning:
Application.enableevents = false

and at the end of your macro:
Application.enableevents = True

Note: Don't gorget to re-enable the events

 

[Jason Morin]

Sub YourMacro()
Application.EnableEvents = False
///rest of your code here///
Application.EnableEvents = True
End Sub

HTH
Jason
Atlanta, GA

 

[Guest]

Thank you!!!! This is exactly what I needed. I couldn't
find it in the help files.