Protecting a Data Validation List cell from being overkeyed

[Ian4212]

Hi,

I have created a data validation cell as a list but want to protect the cell from users inadvertently keying data into it and only being able to select a list member. Can someone please advise how I would achieve this?

Many thanks in advance,

Ian

 

[Ian4212]

Ive sorted this out now using lock cells and protecting worksheet ... thanks all the same

 

[mumps]

You actually don't need to protect the sheet. In the Data Validation window, click the Error Alert tab and put a check mark to the left of "Show error alert ....."

 

[Ian4212]

thanks

 

[mumps]

You are very welcome.