Auto loading of a user form sometimes

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

;-\)

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