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