There are just 3 solutions:

temporarerly disable all events. and turn them on when youre done.
Create a global varaible which is inspected by all concerned events
that you can set to TRUE to let all those events know they should exit
ASAP instead of running
Create a Class module to sink the events of the worksheet in, then you
can disconnect the events by destroying the class variable, and
reconnect by creating it again this is the most pretty, but you need to
know how to handle class modules.

DM Unseen