Steve,
Seems that the RefEdit can only work with the activeWorkbook, so Activate
the required book:

Private Sub UserForm_Initialize()
Workbooks("Book2.xls").Activate
End Sub

NickHK

"Steve" wrote in message
...
I need to let the user select ranges from other open workbooks. The
Refedit
doesn't seem to allow switiching to another workbook when it is in use.
Does
anyone know any way around this for excel 2003?