Load Userform on Workbook_Open()??

[Robert Crandal]

When someone clicks on my macro enabled workbook I want
to immediately display a userform and I want the background
to empty of any sheets. I basically want the userform to act
almost like a "splash screen" which asks the user a question
and then it will load the appropriate sheets and etcc...

Is this even possible?

thanx

 

[Bob Phillips]

In the workbook in question, add

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

'This is workbook event code.
'To input this code, right click on the Excel icon on the worksheet
'(or next to the File menu if you maximise your workbooks),
'select View Code from the menu, and paste the code