When opening Excel user receives "Can't find project Library"

[Corey]

When opening Excel user receives "Can't find project
Library" and when closing he recieves " This command will
stop the debugger" Any ideas? thanks corey

 

[Robert Rosenberg]

You have an Addin or some other Excel file that's loading automatically when
Excel starts and that contains macros with old/bad references to one or more
DLL/code file(s).

1. After Opening Excel, open the Visual Basic Editor (VBE for short) -
Tools-->Macro-->Visual Basic Editor or press Alt+F11

2. If a list of open workbooks does not appear (usually on the left side),
click View-->Project Explorer

3. Click on each bolded project name - ex: VBAProject (Personal.xls)

4. Click Tools-->References

5. Uncheck any checked item that has the word "missing" next to it

6. Click OK, then click the Save button in the VBE to save that project

Note: Some of the projects might be protected, which disables the
Tools-->References command. If after going through each of the unprotected
projects you still get the error, you may need to contact the persons
responsible for those protected projects and either obtain an updated
version or obtain the password to unlock the project.
--
_________________________
Robert Rosenberg
R-COR Consulting Services
Microsoft MVP - Excel
http://www.r-cor.com

 

[corey]

Thanks I will give it a try.

-----Original Message-----
You have an Addin or some other Excel file that's loading automatically when
Excel starts and that contains macros with old/bad references to one or more
DLL/code file(s).

1. After Opening Excel, open the Visual Basic Editor (VBE for short) -
Tools-->Macro-->Visual Basic Editor or press Alt+F11

2. If a list of open workbooks does not appear (usually on the left side),
click View-->Project Explorer

3. Click on each bolded project name - ex: VBAProject (Personal.xls)

4. Click Tools-->References

5. Uncheck any checked item that has the word "missing" next to it

6. Click OK, then click the Save button in the VBE to save that project

Note: Some of the projects might be protected, which disables the
Tools-->References command. If after going through each of the unprotected
projects you still get the error, you may need to contact the persons
responsible for those protected projects and either obtain an updated
version or obtain the password to unlock the project.
--
_________________________
Robert Rosenberg
R-COR Consulting Services
Microsoft MVP - Excel
http://www.r-cor.com





.