Validation....

[mandeepdhami4u]

Hi,

I have names of 5 cities in validation in column A.
We get the drop down menu to select any of this 5 cities in column A.

At times I copy paste names of the cities from other database which is not similar to the names entered in validation.

I want a formula with which colun A is protected and we can only enter data that is there in validation. Copy pasting of other data in column A should not be allowed.

Hope I am able to clear my doubts....

Cheers,
Mandeep

[Peo Sjoblom]

Didn't I tell you earlier that it is not possible to prevent pasting in
validation

--

Regards,

Peo Sjoblom

Excel 95 - Excel 2007
Northwest Excel Solutions
www.nwexcelsolutions.com
"It is a good thing to follow the first law of holes;
if you are in one stop digging." Lord Healey


"mandeepdhami4u"
<[email protected]> wrote in
message news:[email protected]...
>
> Hi,
>
> I have names of 5 cities in validation in column A.
> We get the drop down menu to select any of this 5 cities in column A.
>
> At times I copy paste names of the cities from other database which is
> not similar to the names entered in validation.
>
> I want a formula with which colun A is protected and we can only enter
> data that is there in validation. Copy pasting of other data in column
> A should not be allowed.
>
> Hope I am able to clear my doubts....
>
> Cheers,
> Mandeep
>
>
> --
> mandeepdhami4u
> ------------------------------------------------------------------------
> mandeepdhami4u's Profile:
> http://www.excelforum.com/member.php...o&userid=35841
> View this thread: http://www.excelforum.com/showthread...hreadid=556321
>