As planned, Microsoft released a security patch for an Office ActiveX vulnerability on 12/9/2015. Any dated (and I mean code as old as 10-years) Excel VBA macros with ActiveX controls no longer work post-patching. Here are some links if you need to understand more:
Frankly, the ideal way to repair this issue is to replace the underlying vulnerable ActiveX VBA code.
Where that isn’t practical, the following fix works for Excel 2007 and Excel 2010, but you need a working unpatched machine to start.
Working directory – C:\Users\%Username%\AppData\Local\Temp
Folder and files to copy –
Copy and replace the working folders to the broken machine and the macros should start working again.
Each of the directories above contain uncorrupted *.exd files. The issue is resolved when you replace the corrupted files on the broken PC.
Email me if you need a working copy of the files.
Still digging into Excel 2013…