You could use DataGet External Data New Database Query to pull the
values into your workbook, and base the data validation list on the
query results.

karambos wrote:
I would like to have a drop down menu in a workbook that allows only
values form another workbook that may or may not be closed at the
time.

Is this possible and if so I'd be grateful for any hints, tips and
pointers in the right direction.

Thanks as always




--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html