Hi,

I am creating a list using data validation in a particular cell. I am facing
following problems and i request anyone of you to help me on this.

1) How can protect the list in the particular cell. If i copy the data from
other cell (where there is no validation) and paste in the validation cell
then the list will be removed
2) Sometimes if i enter free text in the list it accepts not throwing error.

Requesting you to guide me to fix this issue.

Christ

Data validation is not at all foolproof. Refer the below link on data
validation.. Take a look at the links provided at the bottom of this page

From Debra Dalgleish
http://www.contextures.com/xlDataVal01.html

If this post helps click Yes
---------------
Jacob Skaria


"Christopher Naveen" wrote:

Hi,

I am creating a list using data validation in a particular cell. I am facing
following problems and i request anyone of you to help me on this.

1) How can protect the list in the particular cell. If i copy the data from
other cell (where there is no validation) and paste in the validation cell
then the list will be removed
2) Sometimes if i enter free text in the list it accepts not throwing error.

Requesting you to guide me to fix this issue.

Christ

Me thinks....

If you uncheck Show Error Alert, you can "type" in non list entries.
If you "copy paste" non list entries it delets the data validation for the
cell.

HTH
Regards,
Howard

"Christopher Naveen" wrote in
message ...
Hi,

I am creating a list using data validation in a particular cell. I am
facing
following problems and i request anyone of you to help me on this.

1) How can protect the list in the particular cell. If i copy the data
from
other cell (where there is no validation) and paste in the validation cell
then the list will be removed
2) Sometimes if i enter free text in the list it accepts not throwing
error.

Requesting you to guide me to fix this issue.

Christ