Load Userform on Workbook_Open()??

  • Thread starter Thread starter Robert Crandal
  • Start date Start date
R

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