Hi,

i use the worksheet change event on one of my sheets, this is fine but when i run another macro which changes this sheet serval times it always, after it changes anything runs the worksheet change event code, and slows the macro down.

i know there is a way to turn off this when running macros but can't remeber the code to do so. i think its something to do with the Application keyword.

any info woud be brill!

thanks

jon