data validation-How do you unlock cells?

[changetires]

How do you unlock cells so you can type directly into a cell that contains a data validation pull down menu? What gives?

Ed

[Nick Hodge]

You will have to remove the data validation as it is using the 'list' option
which only allows selections from the list

Data>Data validation...>clear all

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
www.nickhodge.co.uk
[email protected]HIS


"changetires" <[email protected]>
wrote in message
news:[email protected]...
>
> How do you unlock cells so you can type directly into a cell that
> contains a data validation pull down menu? What gives?
>
> Ed
>
>
> --
> changetires
> ------------------------------------------------------------------------
> changetires's Profile:
> http://www.excelforum.com/member.php...o&userid=35414
> View this thread: http://www.excelforum.com/showthread...hreadid=560439
>

[Gord Dibben]

Turn off the Error Alert in the DV dialog.


Gord Dibben MS Excel MVP

On Tue, 11 Jul 2006 15:59:56 -0400, changetires
<[email protected]> wrote:

>
>How do you unlock cells so you can type directly into a cell that
>contains a data validation pull down menu? What gives?
>
>Ed

[Debra Dalgleish]

If you have a data validation list, you can type a valid entry, instead
of selecting it from the list.
If you want the list, but you want to be able to type other values in
the cell:

Select the cell
Choose Data>Validation
Select the Error Alert tab
--Remove the check mark from 'Show error alert after invalid data
is entered
--OR, in in the dropdown list for Style, choose Warning or Information.

changetires wrote:
> How do you unlock cells so you can type directly into a cell that
> contains a data validation pull down menu? What gives?
>
> Ed
>
>


--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html