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

Use data|Validation instead?

How did you create the dropdown?

Icmeler wrote:

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

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

"Dave Peterson" wrote:

Use data|Validation instead?

How did you create the dropdown?

Icmeler wrote:

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

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

Icmeler wrote:

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

"Dave Peterson" wrote:

Use data|Validation instead?

How did you create the dropdown?

Icmeler wrote:

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


--

Dave Peterson

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" wrote:

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

Icmeler wrote:

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

"Dave Peterson" wrote:

Use data|Validation instead?

How did you create the dropdown?

Icmeler wrote:

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


--

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.)

Icmeler wrote:

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" wrote:

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

Icmeler wrote:

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

"Dave Peterson" wrote:

Use data|Validation instead?

How did you create the dropdown?

Icmeler wrote:

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


--

Dave Peterson


--

Dave Peterson

Thanks for your help.

"Icmeler" wrote:

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