This DID work on my PC, but I send it to the client and on their PC with
Office 2K, they get an automation error (with "unknown" as error number) in

Sub Auto_Open()
Userform1.show
End Sub

I tried saving as a Excel 95,97, 2000 file and then the XP version, BUT
their server got a virus today and they are blocking all attachments until
Monday.

SO does anyone have a clue? Was my guess of version conflict close?



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