Prevent saving a worksheet is some cells contain certain text!

[josullivan601632]

Hi everyone. I have created a rather nifty worksheet for my colleague to complete, I have added a macro that jumps to the next cell to complete so users dont have to manually move to the next cell and that works great. There are cells which at the moment I have a drop down box for users to select "yes" or "no" and the master is saved with "select" in those cells to prompt the user to fill in that cell. As the "yes" and "no" options are really important and the users are now forgetting to "select", I want to add something that stops the users saving the worksheet if those cells still contain "select". Can I do this, would this effect the other macro I have? Any help would be fantastic!

 

[mumps]

My pleasure.