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

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"
<mandeepdhami4u.2a3i8z_1151469902.1621@excelforu m-nospam.com wrote in
message news:mandeepdhami4u.2a3i8z_1151469902.1621@excelfo rum-nospam.com...

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