I have a excel spreadsheet which I want to protect. There is a data validation list that use INDIRECT formula to display values from a table. I want the user to be able to select values from that list, but I don't want the user to be able to remove the text displayed in the cell. Can that be done without VBA?
0
votes
1 Answers
0
votes
Yes. If i understand you correctly you ensure that you have unchecked the locked box for the cells containing the data validation. Right click format cells -> protection -> uncheck box Locked. And when setting up your data validation ensure you uncheck the Ignore blank box. Then when sheet is protected user can only select from drop down list. They can't delete what is in the cell.
