VBA error - Can't find project or library

%3CLINGO-SUB%20id%3D%22lingo-sub-321653%22%20slang%3D%22en-US%22%3EVBA%20error%20-%20Can't%20find%20project%20or%20library%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-321653%22%20slang%3D%22en-US%22%3E%3CP%3EHello%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20an%20issue%20with%20VBA%2C%20I%20created%20a%20duff%20macro%20and%20don't%20know%20where%20it%20is%20saved.%20I%20get%20the%20following%20error%20mesage%20when%20opening%20Excel%3A%20'Can't%20find%20project%20or%20library'.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20followed%20the%20help%20button%20and%20it%20suggests%20that%20i%20go%20to%20references%20within%20the%20VBA%20and%20untick%20any%20that%20say%20'missing'%20however%20I%20do%20not%20have%20any%20'missing'%20references.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20can%20not%20use%20any%20of%20my%20normal%20macros%20and%20if%20I%20click%20'view%20macros'%2C%20excel%20crashes.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20am%20at%20a%20loss%20as%20to%20how%20to%20solve%20this%20issue.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%20in%20advance.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-321653%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EMacros%20and%20VBA%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Highlighted
Occasional Visitor

Hello,

 

I have an issue with VBA, I created a duff macro and don't know where it is saved. I get the following error mesage when opening Excel: 'Can't find project or library'.

 

I have followed the help button and it suggests that i go to references within the VBA and untick any that say 'missing' however I do not have any 'missing' references.

 

I can not use any of my normal macros and if I click 'view macros', excel crashes.

 

I am at a loss as to how to solve this issue.

 

Thanks in advance.

 

0 Replies