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.