That is what would normally happen provided you do not close  the userform  or
the workbook  it belongs to. the form  will still be open  in the background
when the extra workbook is opened and when that workbook is closed the focus
will return to the form.