I currently have a survey that is used by people nationally to rate a
department. They need to answer 9 questions then click "Submit" which has a
macro attached to save and hide their worksheet.

How can I add into the macro, code to stop the macro from running and
display an error box if someone tries to submit without having populated all
the fields (eg: cell L8)?

--
scheduler