Can't Find Project or Library Error

V

Vick

My users are getting the following error. "Can't Find Project or Library
Error" After clicking help I've seemed to trace it back to a reference called
"Ref Edit Control" but I'm not sure where to go from here. How do I find out
what I'm doing in VBA thats using that reference? Or preferably how do I
avoid this error in the future with my users? Any help would be greatly
appreciated.

Thanks
 
B

Bob Flanagan

In the VB Editor, click Tools, References. Unclick the reference to
RefEdit. It is not needed, but a bug in an SP release appears to cause a
problem on some PCs. Anytime you add a refedit box to your project, you
will need to repeat this task. If you have a reference to Microsoft Office
Object Library, remove it also (same problem).

Bob Flanagan
Macro Systems
http://www.add-ins.com
Productivity add-ins and downloadable books on VB macros for Excel
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top