Exel VBA- userform startup problem

  • Thread starter Thread starter officemanager
  • Start date Start date
O

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
 
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.
 
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
 
Back
Top