View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Dave Peterson Dave Peterson is offline
external usenet poster
 
Posts: 35,218
Default protect validation messages

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.



tikchye_oldLearner57 wrote:

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


--

Dave Peterson