Combo Box List in another workbook
 

I need a little help. I have created an excel spreadsheet that uses combo
boxes for data entry. The lists for these combo boxes reside in a seperate
workbook. The only way that I can get the combo boxes to populate with the
lists is for both workbooks to be open. Is there any way to get around
having both boxes open? I do not want the user to have to open both
workbooks in order to enter data into one.