vba Windows 更新后 Excel 2010 ActiveX 控件不再工作
声明：本页面是StackOverFlow热门问题的中英对照翻译，遵循CC BY-SA 4.0协议，如果您需要使用它，必须同样遵循CC BY-SA许可，注明原文地址和作者信息，同时你必须将它归于原作者（不是我）：StackOverFlow
原文地址: http://stackoverflow.com/questions/27414170/
Warning: these are provided under cc-by-sa 4.0 license. You are free to use/share it, But you must attribute it to the original authors (not me):
StackOverFlow
Excel 2010 ActiveX Controls No Longer Working After Windows Updates
提问by Brady
So at work I ran into this issue after I installed the most recent Windows 7 updates (including Microsoft Office 2010 updates) - the date up the update was today (Dec 12, 2014).
所以在工作中，我在安装了最新的 Windows 7 更新（包括 Microsoft Office 2010 更新）后遇到了这个问题 - 更新的日期是今天（2014 年 12 月 12 日）。
After the update, I opened my macro enabled workbook in Excel 2010 and basically anything that referenced ActiveX controls (checkboxes, buttons) no longer worked. My auto_open was checking checkboxes and couldn't run... it kept erroring at the first checkbox check. The buttons are also no longer clickable.
更新后，我在 Excel 2010 中打开了启用宏的工作簿，基本上所有引用 ActiveX 控件（复选框、按钮）的内容都不再起作用。我的 auto_open 正在检查复选框并且无法运行......它在第一个复选框检查时一直出错。按钮也不再可点击。
Before you say it, I have checked my trust settings and allowed all ActiveX and Macros, but no change. If anyone has any advice, I'm all ears. Due to me not being an admin, I cannot due too many things as far as Windows goes.
在你说之前，我已经检查了我的信任设置并允许所有 ActiveX 和宏，但没有更改。如果有人有任何建议，我会全神贯注。由于我不是管理员，就 Windows 而言，我不能承担太多事情。
回答by roaseao
We had this somewhat shocking issue yesterday on several machines with Excel 2007.
昨天我们在几台装有 Excel 2007 的机器上遇到了这个令人震惊的问题。
By rolling back Security updates for office one by one, we determined that this was being caused by update KB2596927from 9 December 2014 - Link
通过一一回滚 Office 的安全更新，我们确定这是由KB25969272014 年 12 月 9 日的更新引起的-链接
After this update, not only did many macro-enabled worksheets break down upon activating macros due to their ActiveX controls being killed, but also no classic ActiveX controls (button, checkbox, etc.) could be inserted into a blank workbook any longer!
此次更新后，不仅许多启用宏的工作表在激活宏时由于其 ActiveX 控件被杀死而崩溃，而且不再可以将经典的 ActiveX 控件（按钮、复选框等）插入到空白工作簿中！
CONFIRM AS SOLVED: I can confirm that the answer to delete the file C:\Users\USERNAME\AppData\Local\Temp\Excel8.0\MSForms.exdhas worked for me!
确认已解决：我可以确认删除文件的答案C:\Users\USERNAME\AppData\Local\Temp\Excel8.0\MSForms.exd对我有用！
Thank you guys!
谢谢你们！
Here is more information on EXD files
这是有关EXD 文件的更多信息
This was resolved also in another post on this forum
这也在本论坛的另一篇文章中得到解决
回答by cracki
Resolved issue !
已解决问题！
- Close Excel
- Rename or delete this file (at your own risk) : C:\Users\USERNAME\AppData\Local\Temp\Excel8.0\MSForms.exd
- 关闭 Excel
- 重命名或删除此文件（风险自负）：C:\Users\USERNAME\AppData\Local\Temp\Excel8.0\MSForms.exd
It would be rebuild after Excel reopens. My ActiveX et macros are working good !
Excel重新打开后将重建。我的 ActiveX et 宏运行良好！
Have a good day !
祝你有美好的一天 ！
Cracki
克拉基
回答by denfromufa
As a quick fix and workaround use this tool:
作为快速修复和解决方法，请使用此工具：
http://go.microsoft.com/?linkid=9875022
http://go.microsoft.com/?linkid=9875022
https://support.microsoft.com/kb/3025036
https://support.microsoft.com/kb/3025036
Basically remove all “.exd” files which represent the cache of the forms.
基本上删除所有代表表单缓存的“.exd”文件。
