I have a worksheet with an ActiveX control (created by me) on it. The control has worked fine up to now, but now it is in a sorry state.

1. The control is shrunken to just a point; it does not function, but it is pickable in Design Mode and can be expanded. Once expanded, it has a blank UI (it's a button and the outline is greyed out and it has no caption)

2. Tools/References shows it as a Missing Reference (it's in the #5 position of 10 listed), although the pathname is correct and the control (.ocx) is located there

3. In code that I have written to list references, the reference count is 11!!! Reference #5 is not listed, but the 10th one listed is the correct name for the Missing Reference

4. Reference #5 cannot be deleted programmatically as it is a "Default Reference" and they cannot be deleted

5. If I delete the worksheet that hosts the ActiveX control, the missing reference box can be unchecked. Then I just have to recreate the worksheet

Any ideas on how to clear the missing reference without deleting the host worksheet?

Steve,

Try the following. Close Excel. Go to the Windows Start menu, choose Run and
unregister the control with

RegSvr32 "C:\path\controlname.ocx" /u

Then re-register the control with

RegSvr32 "C:\path\controlname.ocx"

Now go back to Excel/VBA and see if this clears things up.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com

"Steve Sergev" wrote in message
...
I have a worksheet with an ActiveX control (created by me) on it. The
control has worked fine up to now, but now it is in a sorry state.

1. The control is shrunken to just a point; it does not function, but it
is pickable in Design Mode and can be expanded. Once expanded, it has a
blank UI (it's a button and the outline is greyed out and it has no
caption).

2. Tools/References shows it as a Missing Reference (it's in the #5
position of 10 listed), although the pathname is correct and the control
(.ocx) is located there.

3. In code that I have written to list references, the reference count is
11!!! Reference #5 is not listed, but the 10th one listed is the correct
name for the Missing Reference.

4. Reference #5 cannot be deleted programmatically as it is a "Default
Reference" and they cannot be deleted.

5. If I delete the worksheet that hosts the ActiveX control, the missing
reference box can be unchecked. Then I just have to recreate the worksheet.

Any ideas on how to clear the missing reference without deleting the host
worksheet?