SHow user form when opening workbook

W

Wanna Learn

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
 
J

Jim Rech

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