ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   protect validation messages (https://www.excelbanter.com/excel-discussion-misc-queries/138681-protect-validation-messages.html)

tikchye_oldLearner57

protect validation messages
 
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

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


All times are GMT +1. The time now is 12:21 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com