list protection

[Icmeler]

I have drop down lists in various cells. I want to protect the cell so that
users can select from the list but not type directly into the cell. How do I
do this?

Thankyou

 

[Dave Peterson]

Use data|Validation instead?

How did you create the dropdown?

 

[Icmeler]

I created the dropdown by Data/Validation
The list is on a separate sheet.

 

[Dave Peterson]

Make sure you stop invalid data on the Data|Validation|Error alert tab.

 

[Icmeler]

I've checked the box is ticked and it is.
If I lock the cell I can't pick from the drop down list.
If I unprotect I can either choose from the list or write directly in the
cell.

 

[Dave Peterson]

But if you type into the cell directly, doesn't that have to match one of the
values in that list?

If I type something that doesn't match, then I get a message back from
Data|Validation.

(Copy|pasting is a different problem, though.)

I've checked the box is ticked and it is.
If I lock the cell I can't pick from the drop down list.
If I unprotect I can either choose from the list or write directly in the
cell.

 

[Icmeler]

I wanted the cell to only allow picking from the list.

 

[Dave Peterson]

I don't think that there's anything built into excel that would allow that--even
comboboxes and dropdowns allow typing.

I wanted the cell to only allow picking from the list.

 

[Icmeler]

Thanks for your help.