protect validation messages

  • Thread starter tikchye_oldLearner57
  • Start date
T

tikchye_oldLearner57

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 :)
 
D

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.
 
Top