Hi does anyone know if there is a straightforward way of preventing an excel sheet being emailed whilst a validation formula on the sheet says its incomplete? Basically I have a form that was previously completed in the most imaginative of fashions if I did not use validated answers in drop down menus. However, a couple of my colleagues have a habit of never fully completing the form and ignoring the big red letters that say "Number of incomplete sections: X". So rather than me having to keep sending it back and repeating myself can I do something to the file to stop it being sent unless the count I have in "Number of incomplete sections" shows zero? Your help as always greatly appreciated.