Remove a missing reference that is in use?
 

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 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

Remove a missing reference that is in use?
 

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.

On Mar 21, 4:31*pm, GS wrote:
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 athttp://www.eternal-september.org
ClassicVB Users Regroup! comp.lang.basic.visual.misc

Remove a missing reference that is in use?
 

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.

On Mar 21, 4:31*pm, GS wrote:
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 athttp://www.eternal-september.org
ClassicVB Users Regroup! comp.lang.basic.visual.misc

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.

--
Garry

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