Auto loading of a user form sometimes
 

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?

Auto loading of a user form sometimes
 

Then you will need, at least, to tell us the exact wording of the error
message.

I am guessing the code behind the userform is reference a library that is
not specified to be a reference for the project on the other PC.

--
http://www.standards.com/; Howard Kaikow's web site.
------------------------------------------------
";-)" wrote in message
...
Yes, I think that is how it is, since it works fine on my PC.



"Howard Kaikow" wrote in message
...
You need to have a form named Userform1 included in the workbook that
has
the Auto_Open code.

--
http://www.standards.com/; Howard Kaikow's web site.
------------------------------------------------
";-)" wrote in message
...
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?