MacMasta,

Use the Workbook_Open event:
Private Sub Workbook_Open()
    UserForm1.Show
End Sub