Can you put another cell on the worksheet and link it to the other workbook.
Then use a formula in your validation < your new cell?
HTH

"Neo1" wrote:


Hello I tried performing a validation check so that a value is less than
or equal to a value in another workbook, but it doesnt let me choose the
cell from the other workbook I guess it has to be in the same worksheet
your applying the validation check in right? isnt there a way i can
choose the cell from the other workbook?

Thanks a lot
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