HI ,

My Client is using macros in Excel 2010. They claim it was all working fine until the december patches were deployed.

Initially they were getting Runtime error 32809. We tried the solution from the forum http://stackoverflow.com/questions/27591879/suddenly-several-vba-macro-errors-mostly-32809 but that throw the new runtime error 57121.

Note : The machines did not install the patch KB2553154 as it only applicable for Office 2010 SP2 and the client environment is using Office 2010 SP1

Request your help to solve the issue.

http://stackoverflow.com/questions/27591879/suddenly-several-vba-macro-errors-mostly-32809

Hi,

Do you mind sharing us the update list of the December patches that you were deployed? As far as I know, the Form Controls (FM20.dll) are no longer working as expected after installing MS14-082 Microsoft Office Security Updates for December 2014.

But MS14-082 Microsoft Office Security Updates for December 2014 apply to Microsoft Office 2010 Service Pack 2, since you said you were using Office 2010 SP1, you can't install them. Thus, I suppose that this issue might be not due to the update patches.

I recommend you try to use a test machine, and then install the Office 2010 SP2. Next, install the hotfixes and check if they are helpful.

FM20	March 10, 2015 update for Office 2010 (KB2920813)	http://support.microsoft.com/kb/2920813
Excel	MS15-022: Description of the security update for Microsoft Excel 2010: March 10, 2015 (KB2956142)	http://support.microsoft.com/kb/2956142
Word	MS15-022: Description of the security update for Microsoft Word 2010: March 10, 2015 (KB2956139)	http://support.microsoft.com/kb/2956139
PowerPoint	MS15-022: Description of the security update for Microsoft PowerPoint 2010: March 10, 2015 (KB2920812)	http://support.microsoft.com/kb/2920812
Access	March 10, 2015 update for Access 2010 (KB2837601)	http://support.microsoft.com/kb/2837601
Visio	March 10, 2015 update for Visio 2010 (KB2878283)	http://support.microsoft.com/kb/2878283

Quote From:

http://blogs.technet.com/b/the_microsoft_excel_support_team_blog/archive/2014/12/13/forms-controls-stop-working-after-december-2014-updates-.aspx

If you want to do further troubleshooting about coding, I recommend you post the question to MSDN forum:

http://social.msdn.microsoft.com/Forums/en-US/home?forum=exceldev&filter=alltypes&sort=lastpostdesc

The reason why we recommend posting appropriately is you will get the most qualified pool of respondents, and other partners who read the forums regularly can either share their knowledge or learn from your interaction with us. Thank you for your understanding.

George Zhao
TechNet Community Support

HI George,

Our Technical support executive upgraded the few machines to Office 2010 SP2 and then ran the fixit from https://support.microsoft.com/en-us/kb/3025036 and it did resolve the problem.

However in our enviroment currently Office 2010 SP2 is not used and hence would like to know if there is any other solution to the problem. 

Please find the update list as requested, we have deployed the updates for December 2014 and January 2015 in January.

Security Update for Windows 7 (KB2991963)	MS14-078
Security Update for Windows 7 for x64-based Systems (KB2991963)	MS14-078
Security Update for Windows 7 (KB3002885)	MS14-079
Security Update for Windows 7 for x64-based Systems (KB3002885)	MS14-079
Cumulative Security Update for Internet Explorer 9 for Windows 7 for x64-based Systems (KB3008923)	MS14-080
Cumulative Security Update for Internet Explorer 11 for Windows 7 (KB3008923)	MS14-080
Cumulative Security Update for Internet Explorer 8 for Windows 7 for x64-based Systems (KB3008923)	MS14-080
Cumulative Security Update for Internet Explorer 8 for Windows 7 (KB3008923)	MS14-080
Cumulative Security Update for Internet Explorer 10 for Windows 7 for x64-based Systems (KB3008923)	MS14-080
Cumulative Security Update for Internet Explorer 9 for Windows 7 (KB3008923)	MS14-080
Cumulative Security Update for Internet Explorer 11 for Windows 7 for x64-based Systems (KB3008923)	MS14-080
Cumulative Security Update for Internet Explorer 10 for Windows 7 (KB3008923)	MS14-080
Security Update for Microsoft Word 2013 (KB2910916) 32-Bit Edition	MS14-081
Security Update for Microsoft Word 2010 (KB2899519) 32-Bit Edition	MS14-081
Security Update for Microsoft Word 2010 (KB2899519) 64-Bit Edition	MS14-081
Security Update for Microsoft Office 2010 (KB2553154) 32-Bit Edition	MS14-082
Security Update for Microsoft Office 2010 (KB2553154) 64-Bit Edition	MS14-082
Security Update for Microsoft Office 2013 (KB2726958) 32-Bit Edition	MS14-082
Security Update for Microsoft Excel 2010 (KB2910902) 64-Bit Edition	MS14-083
Security Update for Microsoft Excel 2010 (KB2910902) 32-Bit Edition	MS14-083
Security Update for Microsoft Excel 2013 (KB2910929) 32-Bit Edition	MS14-083
Security Update for Internet Explorer 8 for Windows 7 for x64-based Systems (KB3012176)	MS14-084
Security Update for Internet Explorer 8 for Windows 7 (KB3012176)	MS14-084
Security Update for Windows 7 (KB3013126)	MS14-085
Security Update for Windows 7 for x64-based Systems (KB3013126)	MS14-085
Security Update for Windows 7 (KB3023266)	MS15-001
Security Update for Windows 7 for x64-based Systems (KB3023266)	MS15-001
Security Update for Windows 7 for x64-based Systems (KB3020393)	MS15-002
Security Update for Windows 7 (KB3021674)	MS15-003
Security Update for Windows 7 for x64-based Systems (KB3021674)	MS15-003
Security Update for Windows 7 for x64-based Systems (KB3020388)	MS15-004
Security Update for Windows 7 (KB3019978)	MS15-004
Security Update for Windows 7 for x64-based Systems (KB3019978)	MS15-004
Security Update for Windows 7 for x64-based Systems (KB3020387)	MS15-004
Security Update for Windows 7 (KB3020388)	MS15-004
Security Update for Windows 7 (KB3022777)	MS15-005
Security Update for Windows 7 for x64-based Systems (KB3022777)	MS15-005
Security Update for Windows 7 (KB3019215)	MS15-008
Security Update for Windows 7 for x64-based Systems (KB3019215)	MS15-008
Security Update for Windows 7 (KB3020387)	MS15-004

Hi,

Based on the list:

===

Security Update for Microsoft Word 2013 (KB2910916) 32-Bit Edition	MS14-081
Security Update for Microsoft Word 2010 (KB2899519) 32-Bit Edition	MS14-081
Security Update for Microsoft Word 2010 (KB2899519) 64-Bit Edition	MS14-081
Security Update for Microsoft Office 2010 (KB2553154) 32-Bit Edition	MS14-082
Security Update for Microsoft Office 2010 (KB2553154) 64-Bit Edition	MS14-082
Security Update for Microsoft Office 2013 (KB2726958) 32-Bit Edition	MS14-082
Security Update for Microsoft Excel 2010 (KB2910902) 64-Bit Edition	MS14-083
Security Update for Microsoft Excel 2010 (KB2910902) 32-Bit Edition	MS14-083
Security Update for Microsoft Excel 2013 (KB2910929) 32-Bit Edition === This issue is still caused by the December Update, see this blog: http://blogs.technet.com/b/office_sustained_engineering/archive/2014/12/12/office-2010-activex-disabled-december-update-kb2553154.aspx

Please try the workaround:

To manually remove cached control extender objects, follow these steps:

1. In Windows Explorer, open the %TEMP% folder, and then search for "*.exd" in all subfolders.
2. Delete all instances in which that file is found. This includes all subfolders.

Note The .exd files will be re-created automatically when you use the new controls the next time that you use VBA. These extender files will be under the user's profile and may also be in other locations, such as the following folders:

• %appdata%\microsoft\forms
• %temp%\excel8.0
• %temp%\word8.0
• %temp%\PPT11.0
• %temp%\vbe

http://support.microsoft.com/en-us/kb/3025036

Regards,

George Zhao
TechNet Community Support

HI George,

The Fixit was tried on all machines irrespective of their Service Packs. This fixed the problem on machines using Office SP2 but there are about 14 users who doesn't have SP2 installed are experiencing the problem.

Hi,

Have you tried the above workaround (manually remove cached control extender objects)? If it still does not work, I'm afraid we need to install Office 2010 SP2 and then install the Hotfixs that have been released in the March 10th.

Regards,

George Zhao
TechNet Community Support

It worked after installing Office 2010 SP2 , KB2553154 and running the Microsoft Fixit 51031.