vba - Microsoft Excel ActiveX Controls Disabled?

Question

I have some Excel worksheets that use ActiveX checkboxes to control certain activity. They worked recently but today started to give errors. I was alerted to this by a colleague, but it was still working on my computer. I checked his version of Excel against mine and his was newer. I noticed there were new Windows updates, so I did the update. After I applied pending updates, it now no longer works on my computer. I cannot check the ActiveX checkboxes any longer, and, as a part of trying to debug, it appears I cannot even add an ActiveX control to any worksheet, even a new worksheet, any more. I get an error dialog that says, "Cannot insert object." (I can still add form controls, just not ActiveX.) Anyone else experiencing this after a recent update? Any suggestions?

Thanks,

Mike

Answer 1

From other forums, I have learned that it is due to the MS Update and that a good fix is to simply delete the file MSForms.exd from any Temp subfolder in the user's profile. For instance:

C:Users[user.name]AppDataLocalTempExcel8.0MSForms.exd

C:Users[user.name]AppDataLocalTempVBEMSForms.exd

C:Users[user.name]AppDataLocalTempWord8.0MSForms.exd

Of course the application (Excel, Word...) must be closed in order to delete this file.