dropdown list not working in validation

[excel5111987]

Hi,

I have applied validation in sheet no.1 in several columns and protected those columns with passowrd, but the user are not able to select list from validation in protected columns.


So, Please suggest solution so that user can select and enter list from validation in protected columns

example sheet is also attached .