Hello,

I have a dropdown in a worksheet (Sheet1, Cell F1) that gets populated from another worksheet (Sheet2, column A). I want to protect the sheet1 so that the users should not be able to select another value from the drop down once the sheet is locked. I tried protecting the sheet but even after protecting the sheet1 the drop down list is available and the users can change the value of the dropdown (say from January to February)

How can I protect the sheet1 so that once the sheet is protected the users should not be able to select and change the value of the dropdown?

Any help is appreciated. Thanks !