In Excel XP: VB Error Message

[Excelprincess]

In Excel, forms were created in VB. The employee used VBA editor, VBA code and two user forms. The employee was able to view and use this form on his home computer and his work PC, however when emailed as an attachment to another co-worker to begin using this form, the co-worker received this message, "Microsoft Visual Basic, Compile Error, Can't find project or library". Please help with a fix.

 

[SteveBausch]

http://support.microsoft.com/default.aspx?scid=kb;en-us;Q244167

is one place to investigate.

A quick and dirty is to have the recipient open the VBA editor, and recompile the project. May be helpful.

 

[xlbo]

Look at the tools>References in VBE for the user who created the file
check this against what is ticked in Tools>References for the user who gets the error message. My guess is that the user who is getting the error doesn't have one of the necessary references ticked Rgds
Geoff
"Some cause happiness wherever they go; others whenever they go."
-Oscar Wilde