Remove a missing reference that is in use?

[S]

Hello,

When my work converted to Office 2010 a spreadsheet that I maintain
started throwing error messages.


When I check my references there is a reference listed that is
missing:

MISSING: Microsoft Calendar Control 11.0

I thought it would be easy and I could just uncheck the reference as
the spreadsheet no longer uses the calendar, but when I try to do that
I get an error that says "Can't remove control or reference; in use".

Does anyone know how to remove a reference that is missing, but VBa
still thinks it is in use?

Thanks in advance for any help.

 

[GS]

S formulated the question :

Hello,

When my work converted to Office 2010 a spreadsheet that I maintain
started throwing error messages.


When I check my references there is a reference listed that is
missing:

MISSING: Microsoft Calendar Control 11.0

I thought it would be easy and I could just uncheck the reference as
the spreadsheet no longer uses the calendar, but when I try to do that
I get an error that says "Can't remove control or reference; in use".

Does anyone know how to remove a reference that is missing, but VBa
still thinks it is in use?

Thanks in advance for any help.

Remove all the calendar controls first, then clear the checkbox in
References dialog.

 

[S]

Thanks Garry,

I thought I had deleted all the Calendar controls, but maybe I missed
one. I cannot see any on any of the sheets anywhere. Is there a way
I can search for controls and delete them?

Thanks again.

 

[GS]

S explained on 3/22/2011 :

Thanks Garry,

I thought I had deleted all the Calendar controls, but maybe I missed
one. I cannot see any on any of the sheets anywhere. Is there a way
I can search for controls and delete them?

Thanks again.

While you may have physically deleted all instances of the control,
there may still be references to it in code modules. These must also be
deleted.