data validation

C

cindy willard

how do I prevent a user from saving a workbook if there
are cells left blank?
 
C

cindy willard

Sorry, I sure did not make my original question very
clear. What I want to do is make sure the users enter
required information into specific cells; such as:

department number(which is a 5-digit text field)
date of hire
rate of pay

I have created a template for the users and would like to
prevent them from saving the file if the above cells are
left blank.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top