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

--
Message posted from http://www.ExcelForum.com

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.

--
Regards,
Tom Ogilvy

"officemanager " wrote in
message ...
I would like to have my userform in Exel 2002 startup on top of the
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.


---
Message posted from http://www.ExcelForum.com/

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
-------------------
Private Sub Workbook_Open(
-------------------


--
Message posted from http://www.ExcelForum.com