Code to open a another workbook from a macro, but have it opened and not be the active

Try hiding the workbook you are opening before opening the userform.

Private Sub Workbook_Open()
    ThisWorkbook.Windows(1).Visible = False
    UserForm1.Show
End Sub