Home

"Can't find project or library" error message

%3CLINGO-SUB%20id%3D%22lingo-sub-768877%22%20slang%3D%22en-US%22%3E%22Can't%20find%20project%20or%20library%22%20error%20message%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-768877%22%20slang%3D%22en-US%22%3E%3CP%3EI%20am%20trying%20to%20use%20a%20transparent%20shape%20on%20a%20column%20and%20changing%20the%20name%20of%20the%20shape%20to%20%22Col%20A%22%2C%20%22Col%20B%22%20etc.%26nbsp%3B%20When%20I%20press%20enter%20I%20get%20%22Can't%20find%20project%20or%20library%22.%26nbsp%3B%20This%20brings%20up%20a%20window%20(from%20Tools-References)%20listing%20Available%20References.%26nbsp%3B%20Four%20objects%20are%20listed.%26nbsp%3B%20No%20objects%20listed%20%22MISSING%22.%26nbsp%3B%20Can%20somebody%20help%20me%20figure%20this%20out%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-768877%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EMacros%20and%20VBA%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-769087%22%20slang%3D%22en-US%22%3ERe%3A%20%22Can't%20find%20project%20or%20library%22%20error%20message%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-769087%22%20slang%3D%22en-US%22%3EIs%20there%20any%20VBA%20code%20in%20your%20file%3F%20Which%20type%20of%20shape%20are%20you%20adding%20precisely%3F%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-772054%22%20slang%3D%22en-US%22%3ERe%3A%20%22Can't%20find%20project%20or%20library%22%20error%20message%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-772054%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F22322%22%20target%3D%22_blank%22%3E%40Jan%20Karel%20Pieterse%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20am%20taking%20a%20beginner%20Udemy%20class%20on%20VBA%20and%20this%20was%20an%20example%20I%20was%20copying%20(which%20worked%20in%20the%20professor's%20samples)%20where%20you%20place%20a%20shape%20on%20top%20of%20a%20column%2C%20rename%20the%20shape%20%22Col%20A%22%20%22Col%20B%22%20etc%2C%20and%20add%20VBA%20macro%20to%20the%20shape%20which%20I%20already%20typed%20into%20the%20code%20window.%26nbsp%3B%20I%20checked%20to%20make%20sure%20it%20was%20an%20exact%20copy%20of%20the%20professor's%20code.%26nbsp%3B%20The%20shape%20is%20a%20rectangle%20from%20the%20shapes%20choices%20at%20the%20top.%26nbsp%3B%20I%20also%20checked%20the%20box%20that%20opened%20for%20the%20object%20libraries%20to%20make%20sure%20it%20matched%20the%20professor's%20libraries%20that%20are%20checked%2C%20and%20they%20are%20the%20same.%26nbsp%3B%20I%20tried%20adding%20other%20libraries%20and%20nothing%20I%20did%20worked.%26nbsp%3B%20Thanks%20for%20your%20help.%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-772099%22%20slang%3D%22en-US%22%3ERe%3A%20%22Can't%20find%20project%20or%20library%22%20error%20message%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-772099%22%20slang%3D%22en-US%22%3EThat%20is%20an%20odd%20problem.%20What%20happens%20if%20you%20do%20the%20same%20on%20a%20new%20workbook%3F%3C%2FLINGO-BODY%3E
Barbara45
New Contributor

I am trying to use a transparent shape on a column and changing the name of the shape to "Col A", "Col B" etc.  When I press enter I get "Can't find project or library".  This brings up a window (from Tools-References) listing Available References.  Four objects are listed.  No objects listed "MISSING".  Can somebody help me figure this out?

3 Replies
Is there any VBA code in your file? Which type of shape are you adding precisely?

@Jan Karel Pieterse 

 

I am taking a beginner Udemy class on VBA and this was an example I was copying (which worked in the professor's samples) where you place a shape on top of a column, rename the shape "Col A" "Col B" etc, and add VBA macro to the shape which I already typed into the code window.  I checked to make sure it was an exact copy of the professor's code.  The shape is a rectangle from the shapes choices at the top.  I also checked the box that opened for the object libraries to make sure it matched the professor's libraries that are checked, and they are the same.  I tried adding other libraries and nothing I did worked.  Thanks for your help. 

That is an odd problem. What happens if you do the same on a new workbook?
Related Conversations