Hi all,

I currently have a Worksheet_Change() procedure based upon values
changing in a certain column of my worksheet.

I now wish to add in some additional code that formats and sucks in
data from another sheet, and do not want the Worksheet_Change()
procedure to kick in until the new pre-formating code has been
completed.

Any ideas how I can accomplish this?

Regards,

andym