Exel VBA- userform startup problem

[officemanager]

I would like to have my userform in Exel 2002 startup on top of th
Excel worksheet (like a splash screen) before the worksheet loads.
What code do I use to make this happen and where would the code go?

Thank you

 

[Tom Ogilvy]

I think you will get a flash of the worksheet/workbook regardless of what
you do, but you can make the application.Visible = False while you show the
userform.

 

[sp00nix]

When you open up your VBA editor, view the code for 'ThisWorkbook' an
enter the following:

Private Sub Workbook_Open()
Application.Visible = False 'Hides Excel
UserForm1.Show 'Shows your form
Application.Visible = True 'Shows Excel once form closes
End Su
Code