Something along the lines of

Private Sub Workbook_Open()
Application.Visible = False
Userform1.Show
Application.Visible = True
End Sub


The application has to open, so you can't totally hide it. It will flash.

--
regards,
Tom Ogilvy


Thanks Tom that has done the trick exactly how I wanted it!