Microsoft has released some Security Updates on December Patch day (2014/12/09), also some critical patches (see Security Bulletin MS14-082) for Microsoft Office. It seems that security update KB2553154 for Microsoft Office 2010 causes serious issues. Some users are reporting, that ActiveX controls and macros fails in Excel 2013. Here a few insights and [hopefully] a cure.
I stumbled uppon this problem browsing some user comments within my German article Microsoft Dezember 2014-Patchday-Nachlese. Some reader wrotes, that since patch day Excel 2013 macros won't work anymore. Buttons to invoke macros wasn't functional anymore (he wrotes, that it affected protected sheets, but I guess, it affects all VBA macros using ActiveX controls).
The user mentioned above was able to fix things using a system restore in Windows – but as an admin he had to troubleshoot 80 clients. So my proposal was, to uninstall the related updates addressed in Security Bulletin MS14-082, Security Bulletin MS14-082 includes several patches:
- Security Update for Microsoft Office 2007 suites (KB2596927)
- Security Update for Microsoft Office 2010 (KB2553154)
- Security Update for Microsoft Office 2013 (KB2726958)
Uninstall of Update KB2553154 for Microsoft Office 2010 solved the macro problem. At this point I was prepared, to do a deeper web search.
Here comes a workaround
I noticed, that somebody has already reported that issue, but user comments indicates, that this issue was gone within a fresh user profile. Somebody tracked it down to the following workaround: Just search for file MSForms.exd, which shall be located in temporary folder
and delete MSForms.exd. The file should rebuild during next Excel 2013 launch, and all VBA macros should work (shall be able, to use ActiveX controls). I haven't tested it yet – maybe somebody, who has successfully used the workaround can drop a comment.
Update: Microsoft has released a FixIt
Microsoft has published KB article 3025036 ("Cannot insert object" error in an ActiveX custom Office solution after you install the MS14-082 security update), that discusses this issue. This article also provides download links for FixIt solutions. Just download the appropriate FixIt and execute the .exe program. Afterward Excel show work as estimated. Hope that helps.
Cookies helps to fund this blog: Cookie settings