You can also insert a line in your macro that turns off the event triggers whilke the macro is running. Be sure you turn them on when the macro ends, however.
For example, before the macro writes anything to the worksheet put in the line
Application.EnableEvents = False
then your code
Application.EnableEvents = True
The Change even will not fire until the next change occurs. This should speed up things for you.