use protection(Tool, protection). Protect the sheet or the cell or a range
you want to prevent someone from changing. To activate protection, the cell
must be locked(Format, protection, mark locked).
Hope it helps, goodluck
=================
"Diana" wrote:

Hi

How can I lock a dropdwown menu only from adding anything other than what I
have on the list. I have the show error alert clicked but it is still
allowing me add to the list. Is there a specific source or data validation I
need to type. I am only want to lock the dropdown menu on my worksheet.

Thank you