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

[Icmeler]

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]

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

[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" 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]

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

[Icmeler]

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

"Dave Peterson" wrote:

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

[Dave Peterson]

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



Icmeler wrote:
>
> I wanted the cell to only allow picking from the list.
>
> "Dave Peterson" wrote:
>
> > 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
> >

--

Dave Peterson

[Icmeler]

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