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

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

DataData validation...clear all

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


"changetires"
wrote in message
...

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

Turn off the Error Alert in the DV dialog.


Gord Dibben MS Excel MVP

On Tue, 11 Jul 2006 15:59:56 -0400, 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

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