By default a DV list cell will accept only what is in the list.

Typing anything not on the list will bring up an error message.

Make sure you have checkmarked Error AlertShow error alert after invalid data
is entered .


Gord Dibben MS Excel MVP

On Sun, 30 Sep 2007 11:57:02 -0700, Kenny
wrote:

How do I not allow typing in a cell that has a list validation?

Thanks!