Remove "Missing" reference in VB-Tools-References

[Alan]

Short Explanation
--------------------
How do I remove a "Missing" reference in VB-Tools-Reference? I tried
un-checking, doesn't work with a msg the reference is 'in use, cannot
remove". I was using the ref earlier, but have deleted all my VB and control
ref's and still cannot uncheck the "Missing" ref. I've tried exiting and
restarting excel, still doesn't work.

Long Explanation
-------------------
I wanted to use a 3rd party 2d sketch package in excel via their *.ocx. I
registered the *.ocx file, added the reference in Excel and added the VB
functions to use the 3rd party package. It worked fine. I've now decided to
stop using the 3rd party package, replacing it with excel drawing functions,
this works ok on my original machine.

However, when I try to copy my excel workbook and addins to a new machine,
there is an error msg "cannot find project or library" during the startup
elsewhere in my vb. I think this is related to the "Missing" ref. I saw a
similar problem earlier on my original machine when the 3rd party *.ocx file
was not registered. I registered the *.ocx file on the original machine and
it worked ok.

Since I'm not using the 3rd party sw, I've deleted all references to the 3rd
party sw in my excel file and addins on the new machine. I still cannot
delete the "Missing" ref in VB editor. The new machine never had the 3rd
party sw installed. The VB - Tools - Ref comments for the 3rd party sw
points to the original machine.

I'm trying to get rid of the "cannot find project or library" errors from
elsewhere in my VB code, but I think the cause of the problem is the
"Missing" 3rd party ref.

thanks.

 

[Alan]

I was unable to remove the "Missing" reference on my new machine which did
not have the 3rd party product installed. The "Missing" references
indirectly caused "cannot find project or library" errors elsewhere in my VB
code. I had to do the following:

- delete the excel workbook and addins from my new machine.

- go back to my original machine which had the 3rd party sw installed.
- remove all references in my VB code to the 3rd party sw.
- remove the VB - Tools reference to the 3rd party sw.
- remove the 3rd party addin.

- make another copy of my workbook and addins on my original machine.
- install the new copy on my new machine.
- the excel workbook and addins now work on my new machine now works.