View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
GS[_2_] GS[_2_] is offline
external usenet poster
 
Posts: 3,514
Default Remove a missing reference that is in use?

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.

--
Garry

Free usenet access at http://www.eternal-september.org
ClassicVB Users Regroup! comp.lang.basic.visual.misc