Control Worksheet_SheetChange Events
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
|