protect validation messages

[Guest]

hi community

i can protect cell from any modification, however, can i protect cell
validation, say a message input only, and yet the cell can be allow for entry
of data ?

thanks community for assistance

 

[Dave Peterson]

You can unlock that cell, apply data|validation (including an input message),
then protect the worksheet.

Be aware that data|validation is easily broken--copy|pasting onto that cell will
destroy it.