Run userForm only when opened manually

  • Thread starter Thread starter ;-\)
  • Start date Start date
;

;-\)

I have a excel sheet that I need to have a usrForm run but only when it is
opened by hand. I will be calling this XLS from a VB program and that
shouldn't run it.

What events should I use to trigger this?
 
Use this sub in a normal module
Alt-F11
Insert>Module in the menubar
paste the sub there
Alt-Q to go back to Excel

Sub Auto_Open()
Userform1.show
End Sub

This will not run if you open the workbook with code
If you place the code in the workbook open event it will run when
you open the workbook with code.
 
Thanks.

This will work for my needs.


Ron de Bruin said:
Use this sub in a normal module
Alt-F11
Insert>Module in the menubar
paste the sub there
Alt-Q to go back to Excel

Sub Auto_Open()
Userform1.show
End Sub

This will not run if you open the workbook with code
If you place the code in the workbook open event it will run when
you open the workbook with code.
 
Back
Top