Is there a way to stop 1 macro activating another macro

[jnathan]

Is there a way to stop a macro activating a Worksheet_Change sub? I need the macro to not activate the Worksheet_Change sub as it causes the macro to take a long time to run.

Any help would be much appreciated!

Thanks

J

 

[DutchDiggy]

At the top of your macro add in:

Application.EnableEvents = False

(at the end turn it on again, right before the END SUB)

Application.EnableEvents = True

 

[jnathan]

Many thanks!!!!

 

[DutchDiggy]

You're welcome! Thanks for the reply it worked out!