SHow user form when opening workbook

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hello I created a user form in VBA . WHenever the workbook is opened I want
the form to show. but I am having problems doing this. Help! thanks
 
In a standard module:

Sub Auto_Open()
Userform1.Show ''using the name of your form if different
End Sub

Naturally this will work only if the user enables macros.
 
Back
Top