VBA - Bring newly opened workbook to front

[mwc0914]

I have a userform and when I click on a button, it opens a new workbook, but the workbook is behind the userform.
I want to bring the new workbook to the front, without having to hide the userform, so when the person is exits the new orkbook, the userform is still there for use.

Thanks
Mike

 

[mwc0914]

Let me clarify...the userform opens a new workbook. The new workbook is not saved. The user has option to save or exit the new workbook when through working with it. When through, the userform is still there.