Can't find project or library error

Question

I am getting the following every now and then on my spreadsheets tat have Macros.  This is a new issue i'm having with excel and running the same Macros for the past two years.  How can I fix this without having to re save my files and re open  them on another machine, re save and then they will work fine for a while

Here is the event viewer error

- <Event xmlns="**http://schemas.microsoft.com/win/2004/08/events/event**">

- <System>

<Provider Name="Schannel" Guid="{1F678132-5938-4686-9FDC-C8FF68F15C85}" />

<EventID>36888</EventID>

<Version>0</Version>

<Level>2</Level>

<Task>0</Task>

<Opcode>0</Opcode>

<Keywords>0x8000000000000000</Keywords>

<TimeCreated SystemTime="2015-05-18T11:45:39.624938400Z" />

<EventRecordID>13285</EventRecordID>

<Correlation />

<Execution ProcessID="824" ThreadID="868" />

<Channel>System</Channel>

<Computer>Larry</Computer>

<Security UserID="S-1-5-18" />

</System>

- <EventData>

<Data Name="AlertDesc">10</Data>

<Data Name="ErrorState">10</Data>

</EventData>

</Event>

Answer 1

After you get the message, go into the VBE

In the project explorer on the left, make sure the problematic workbook is selected

Then go to Tools=>References in the menu (in the vbe).

You should see one or more references marked as "MISSING"

Uncheck that reference.   (if the workbook actually needs that reference, then  you will have to find it on your drive and recreate the reference to it).

Answer 2

that is what I am talking about - but you are not showing a reference as MISSING.  So perhaps this isn't the source of the problem.  Without having the file and experiencing the error, the best I can do is suggest things that do produce the error.

as far as the problematic file, it is the file the excel file that has the focus when the error occurs - so you do have it - but apparently something other than a reference is causing your problem.  It could be caused by an addin for example. 

--

Regards,

Tom Ogilvy