Hi Legacy,

Can you not disable, and subsequently
re-enable, events:

[...]
With Application
.EnableEvents = False
'Perform your actions
.EnableEvents = True
End With
[...]

---
Regards.
Norman


wrote in message
...
I have a class that I created which automatically updates the cell
format based upon the input. The problem I have is that I have
several add-ins that are used to pull data into excel so when I run
those my sheet_change event runs as well and slows down the data
download considerable. I am trying to figure out how to control it so
that if these other add-ins run, then my cell update event won't run
until it is done.

Any ideas?

Thanks