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"