Microsoft Excel ActiveX 控件被禁用? [英] Microsoft Excel ActiveX Controls Disabled?

问题描述

我有一些 Excel 工作表，它们使用 ActiveX 复选框来控制某些活动.他们最近工作，但今天开始出现错误.一位同事提醒我注意这一点，但它仍在我的电脑上运行.我检查了他的 Excel 版本和我的版本，他的版本较新.我注意到有新的 Windows 更新，所以我做了更新.在我应用待处理的更新后，它现在不再适用于我的计算机.我无法再检查 ActiveX 复选框，并且作为尝试调试的一部分，似乎我什至无法将 ActiveX 控件添加到任何工作表，甚至是新工作表.我收到一个错误对话框，提示无法插入对象".(我仍然可以添加表单控件，只是不能添加 ActiveX.)最近更新后还有其他人遇到过这种情况吗?有什么建议吗?

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?

谢谢，

迈克

推荐答案

从其他论坛，我了解到这是由于 MS 更新造成的，一个好的解决方法是简单地从任何 Temp 子文件夹中删除文件 MSForms.exd在用户的个人资料中.例如:

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

当然必须关闭应用程序(Excel、Word...)才能删除此文件.

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

这篇关于Microsoft Excel ActiveX 控件被禁用?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！