0

I have an old spreadsheet that used date picker from MSCOMCT2.OCX. Then the computer I used it on died. Unfortunately the Microsoft KB article that has the download for MSCOMCT2.OCX only has a dead link.

My only recourse is to remove the reference to MSCOMCT2.OCX and use other methods to pick the date. I have removed the object from the spreadsheet and all references I can find to it in the code, but when I go to remove it I get an error message stating that the "Can't remove control or reference, in use"

How can I find where it is still being referenced?

Fr33dan
  • 4,227
  • 3
  • 35
  • 62
  • Can you find a download of the MSCOMCT2.OCX file, then install and register it? Alternatively, try running the [VBA Code Cleaner](http://www.appspro.com/Utilities/CodeCleaner.htm) which often helps me with obscure issues like this. – PeterT Mar 03 '16 at 20:44
  • Do you have any forms? – Nathan_Sav Mar 03 '16 at 20:57
  • @Nathan_Sav I do not – Fr33dan Mar 07 '16 at 14:40
  • @PeterT I could not find a copy on the day that I posted this, I was however finally able to find one over the weekend. – Fr33dan Mar 07 '16 at 14:40

1 Answers1

0

Unfortunately the solution seem to be that you have to have to fix the broken link before you remove it. I finally found a copy of the .cab file at archive.org. Once I installed it following these instructions I was able to open my file and remove the reference without issue.

Community
  • 1
  • 1
Fr33dan
  • 4,227
  • 3
  • 35
  • 62