Form Combo Box RowSource Question
 

I've created a dialogue box form in VB which has a combo box. To populate
the combo box I've created a range in the workbook Personal.xls. For
example, I've created a range named Cntls and in VB assigned the row source
as follows:

ComboBox1.RowSource="Cntls"

This works fine as long as Personal.xls is not hidden. But it does not work
when Personal.xls is hidden. Are there any work arounds or perhaps another
way of populating the Row Source for the Combo Box?