software

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:
gt;
gt; I have drop down lists in various cells. I want to protect the cell so that
gt; users can select from the list but not type directly into the cell. How do I
gt; do this?
gt;
gt; Thankyou

--

Dave Peterson

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

quot;Dave Petersonquot; wrote:

gt; Use data|Validation instead?
gt;
gt; How did you create the dropdown?
gt;
gt; Icmeler wrote:
gt; gt;
gt; gt; I have drop down lists in various cells. I want to protect the cell so that
gt; gt; users can select from the list but not type directly into the cell. How do I
gt; gt; do this?
gt; gt;
gt; gt; Thankyou
gt;
gt; --
gt;
gt; Dave Peterson
gt;

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

Icmeler wrote:
gt;
gt; I created the dropdown by Data/Validation
gt; The list is on a separate sheet.
gt;
gt; quot;Dave Petersonquot; wrote:
gt;
gt; gt; Use data|Validation instead?
gt; gt;
gt; gt; How did you create the dropdown?
gt; gt;
gt; gt; Icmeler wrote:
gt; gt; gt;
gt; gt; gt; I have drop down lists in various cells. I want to protect the cell so that
gt; gt; gt; users can select from the list but not type directly into the cell. How do I
gt; gt; gt; do this?
gt; gt; gt;
gt; gt; gt; Thankyou
gt; gt;
gt; gt; --
gt; gt;
gt; gt; Dave Peterson
gt; gt;

--

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.

quot;Dave Petersonquot; wrote:

gt; Make sure you stop invalid data on the Data|Validation|Error alert tab.
gt;
gt; Icmeler wrote:
gt; gt;
gt; gt; I created the dropdown by Data/Validation
gt; gt; The list is on a separate sheet.
gt; gt;
gt; gt; quot;Dave Petersonquot; wrote:
gt; gt;
gt; gt; gt; Use data|Validation instead?
gt; gt; gt;
gt; gt; gt; How did you create the dropdown?
gt; gt; gt;
gt; gt; gt; Icmeler wrote:
gt; gt; gt; gt;
gt; gt; gt; gt; I have drop down lists in various cells. I want to protect the cell so that
gt; gt; gt; gt; users can select from the list but not type directly into the cell. How do I
gt; gt; gt; gt; do this?
gt; gt; gt; gt;
gt; gt; gt; gt; Thankyou
gt; gt; gt;
gt; gt; gt; --
gt; gt; gt;
gt; gt; gt; Dave Peterson
gt; gt; gt;
gt;
gt; --
gt;
gt; Dave Peterson
gt;

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:
gt;
gt; I've checked the box is ticked and it is.
gt; If I lock the cell I can't pick from the drop down list.
gt; If I unprotect I can either choose from the list or write directly in the
gt; cell.
gt;
gt; quot;Dave Petersonquot; wrote:
gt;
gt; gt; Make sure you stop invalid data on the Data|Validation|Error alert tab.
gt; gt;
gt; gt; Icmeler wrote:
gt; gt; gt;
gt; gt; gt; I created the dropdown by Data/Validation
gt; gt; gt; The list is on a separate sheet.
gt; gt; gt;
gt; gt; gt; quot;Dave Petersonquot; wrote:
gt; gt; gt;
gt; gt; gt; gt; Use data|Validation instead?
gt; gt; gt; gt;
gt; gt; gt; gt; How did you create the dropdown?
gt; gt; gt; gt;
gt; gt; gt; gt; Icmeler wrote:
gt; gt; gt; gt; gt;
gt; gt; gt; gt; gt; I have drop down lists in various cells. I want to protect the cell so that
gt; gt; gt; gt; gt; users can select from the list but not type directly into the cell. How do I
gt; gt; gt; gt; gt; do this?
gt; gt; gt; gt; gt;
gt; gt; gt; gt; gt; Thankyou
gt; gt; gt; gt;
gt; gt; gt; gt; --
gt; gt; gt; gt;
gt; gt; gt; gt; Dave Peterson
gt; gt; gt; gt;
gt; gt;
gt; gt; --
gt; gt;
gt; gt; Dave Peterson
gt; gt;

--

Dave Peterson

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

quot;Dave Petersonquot; wrote:

gt; But if you type into the cell directly, doesn't that have to match one of the
gt; values in that list?
gt;
gt; If I type something that doesn't match, then I get a message back from
gt; Data|Validation.
gt;
gt; (Copy|pasting is a different problem, though.)
gt;
gt; Icmeler wrote:
gt; gt;
gt; gt; I've checked the box is ticked and it is.
gt; gt; If I lock the cell I can't pick from the drop down list.
gt; gt; If I unprotect I can either choose from the list or write directly in the
gt; gt; cell.
gt; gt;
gt; gt; quot;Dave Petersonquot; wrote:
gt; gt;
gt; gt; gt; Make sure you stop invalid data on the Data|Validation|Error alert tab.
gt; gt; gt;
gt; gt; gt; Icmeler wrote:
gt; gt; gt; gt;
gt; gt; gt; gt; I created the dropdown by Data/Validation
gt; gt; gt; gt; The list is on a separate sheet.
gt; gt; gt; gt;
gt; gt; gt; gt; quot;Dave Petersonquot; wrote:
gt; gt; gt; gt;
gt; gt; gt; gt; gt; Use data|Validation instead?
gt; gt; gt; gt; gt;
gt; gt; gt; gt; gt; How did you create the dropdown?
gt; gt; gt; gt; gt;
gt; gt; gt; gt; gt; Icmeler wrote:
gt; gt; gt; gt; gt; gt;
gt; gt; gt; gt; gt; gt; I have drop down lists in various cells. I want to protect the cell so that
gt; gt; gt; gt; gt; gt; users can select from the list but not type directly into the cell. How do I
gt; gt; gt; gt; gt; gt; do this?
gt; gt; gt; gt; gt; gt;
gt; gt; gt; gt; gt; gt; Thankyou
gt; gt; gt; gt; gt;
gt; gt; gt; gt; gt; --
gt; gt; gt; gt; gt;
gt; gt; gt; gt; gt; Dave Peterson
gt; gt; gt; gt; gt;
gt; gt; gt;
gt; gt; gt; --
gt; gt; gt;
gt; gt; gt; Dave Peterson
gt; gt; gt;
gt;
gt; --
gt;
gt; Dave Peterson
gt;

I don't think that there's anything built into excel that would allow that--even
comboboxes and dropdowns allow typing.
Icmeler wrote:
gt;
gt; I wanted the cell to only allow picking from the list.
gt;
gt; quot;Dave Petersonquot; wrote:
gt;
gt; gt; But if you type into the cell directly, doesn't that have to match one of the
gt; gt; values in that list?
gt; gt;
gt; gt; If I type something that doesn't match, then I get a message back from
gt; gt; Data|Validation.
gt; gt;
gt; gt; (Copy|pasting is a different problem, though.)
gt; gt;
gt; gt; Icmeler wrote:
gt; gt; gt;
gt; gt; gt; I've checked the box is ticked and it is.
gt; gt; gt; If I lock the cell I can't pick from the drop down list.
gt; gt; gt; If I unprotect I can either choose from the list or write directly in the
gt; gt; gt; cell.
gt; gt; gt;
gt; gt; gt; quot;Dave Petersonquot; wrote:
gt; gt; gt;
gt; gt; gt; gt; Make sure you stop invalid data on the Data|Validation|Error alert tab.
gt; gt; gt; gt;
gt; gt; gt; gt; Icmeler wrote:
gt; gt; gt; gt; gt;
gt; gt; gt; gt; gt; I created the dropdown by Data/Validation
gt; gt; gt; gt; gt; The list is on a separate sheet.
gt; gt; gt; gt; gt;
gt; gt; gt; gt; gt; quot;Dave Petersonquot; wrote:
gt; gt; gt; gt; gt;
gt; gt; gt; gt; gt; gt; Use data|Validation instead?
gt; gt; gt; gt; gt; gt;
gt; gt; gt; gt; gt; gt; How did you create the dropdown?
gt; gt; gt; gt; gt; gt;
gt; gt; gt; gt; gt; gt; Icmeler wrote:
gt; gt; gt; gt; gt; gt; gt;
gt; gt; gt; gt; gt; gt; gt; I have drop down lists in various cells. I want to protect the cell so that
gt; gt; gt; gt; gt; gt; gt; users can select from the list but not type directly into the cell. How do I
gt; gt; gt; gt; gt; gt; gt; do this?
gt; gt; gt; gt; gt; gt; gt;
gt; gt; gt; gt; gt; gt; gt; Thankyou
gt; gt; gt; gt; gt; gt;
gt; gt; gt; gt; gt; gt; --
gt; gt; gt; gt; gt; gt;
gt; gt; gt; gt; gt; gt; Dave Peterson
gt; gt; gt; gt; gt; gt;
gt; gt; gt; gt;
gt; gt; gt; gt; --
gt; gt; gt; gt;
gt; gt; gt; gt; Dave Peterson
gt; gt; gt; gt;
gt; gt;
gt; gt; --
gt; gt;
gt; gt; Dave Peterson
gt; gt;

--

Dave Peterson

Thanks for your help.

quot;Icmelerquot; wrote:

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