I want to protect a cell that I have a drop down list in, but I still want the drop down list to work.
When I try to protect it, the user is not able to use the drop down list to select other items or macros.
I get this error message
"The cell or chart that you are trying to change is protected and therefore read-only. To modify a protected cell or chart, first remove protection using the Unprotected Sheet command (Review tab, Changes group). You may be prompted for a password."
Best Answer
The dropdown is attached to the cell. That's where it stores the data. The validation will guarantee that the data is valid.
If you haven't already, make sure that the cell is not locked. Right-click the cell and click format cells and then go to the Protection tab. The Locked check box should be unchecked.