Run userForm only when opened manually
 

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?

Run userForm only when opened manually
 

Use this sub in a normal module
Alt-F11
InsertModule 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.


--
Regards Ron de Bruin
(Win XP Pro SP-1 XL2002 SP-2)
www.rondebruin.nl



";-)" wrote in message ...
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?

Run userForm only when opened manually
 

Thanks.

This will work for my needs.


"Ron de Bruin" wrote in message
...
Use this sub in a normal module
Alt-F11
InsertModule 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.


--
Regards Ron de Bruin
(Win XP Pro SP-1 XL2002 SP-2)
www.rondebruin.nl



";-)" wrote in message
...
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?