yes I can but still the error message doesnt appear when i change the
sell from the other worksheet only if i change it from the one that
has been linked which is in the worksheet of the validation check..and
i dont want to enter the value here i want to enter the value in the
other worksheet...what can i do?

Thanks
From John


--
Neo1
------------------------------------------------------------------------
Neo1's Profile: http://www.excelforum.com/member.php...o&userid=30329
View this thread: http://www.excelforum.com/showthread...hreadid=523656