Data Validation

D

dcb1

I have a lot of different areas on my spreadsheet that can't be
changed. I don't want the user to change it. I defined the Name
BLANK with a empty cell. I then went to Data Validation; Settings and
under validation criteria I chose Custom. I entered =BLANK for the
formula. I also gave an error message to notify the user that the
field is restricted and can't be changed. I have these validations in
case the user would unprotect the worksheet. While this works, I
would like to know if there is another way to do this?
 
Y

yclhk

Condsider to use the password to protect the specified cells in the
worksheets rather than to use the data validation. Other users cannot modify
the protected cells without the valid password, message box will also be
shown to the users notifying that the cell is protected.
 

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

Similar Threads

Conditional Data Validation 2
Data validation 3
Conditional Data Validation Options 2
Data validation 10
Data Validation 7
Validation list in data entry form 4
How To Use Range Names In Data Validation Criteria (Not For Lists) 1
Combining two non-contiguous lists into one for data validation, with one range being dynamic 0

Top