What appears to be a reasonable solution to your problem may be at

'Excel: Data Validation lists and hyperlinks, target validation, target
value' (http://tinyurl.com/kn5xjm)

let us know if it worked for you... :Bgr


--
jamescox
------------------------------------------------------------------------
jamescox's Profile: http://www.thecodecage.com/forumz/member.php?userid=449
View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=117339