I want users to enter information in a cell using a drop-down list and nothing else. If I lock the cell and protect the worksheet, it prevents them from using the drop-down list. How do I prevent them from entering any old data and force them to use only the drop-down list?
