I have a Sub set up so when a user makes a change to certain fields it
validates the data. Users are able to add many rows of data and this
validation is fairly transparent to them. Occassionally data will be copied
into the current spreadsheet from another source and because of the number of
fields being simultaneously updated, the Worksheet_Change Sub takes a few
minutes to complete. I am confident the data being inserted already meets
the validation and am wondering if there is a way to Turn off the
Worksheet_Change Sub before I paste the data and then turn it back on after I
am complete?


Matt