I've recently been using a lot of ActiveX check boxes to hide/show certain rows when they are checked or unchecked, and upon running Excel this morning, I've found that I'm getting an error that says "Object library invalid or contains references to object definitions that could not be found" any time I try running one of my ActiveX check boxes.
I've looked into the error a bit via google, and I've found 3 solutions that seem to work for many people, but none have worked for me thus far. The first solution I tried is navigating to appdata/roaming/microsoft/forms and then deleting all .exd files, but to my suprise, there weren't any there. I also believe someone said running Excel should create these .exd files if they are missing, but that isn't happening either.
The second solution I tried was using the command prompt to navigate to Document and Settings, and delete the .exd files via the code "del /S /A:H /A:-H *.EXD", which also failed.
The third solution I tried was going into the Microsoft Visual Basic --> Tools --> References --> Browse --> Navigate to System32 Folder --> Open MSCOMCTL.OCX file --> Make sure Microsoft Windows Common Controls is checked; this has also failed.
Can anyone think of any other possible solutions I could try?
Bookmarks