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

问题描述

我有一些Excel工作表使用ActiveX复选框来控制某些活动。他们最近工作，但今天开始给出错误。我被同事提醒了这一点，但它仍然在我的电脑上工作。我检查了他的版本的Excel对我的，他是新的。我注意到有新的Windows更新，所以我做了更新。在我应用未完成的更新之后，它现在不再适用于我的电脑。我不能再检查ActiveX复选框，并且作为尝试调试的一部分，似乎甚至不能将ActiveX控件添加到任何工作表，甚至是新的工作表。我收到一个错误对话框，说无法插入对象。 （我仍然可以添加表单控件，只是不是ActiveX。）最近更新后遇到这种情况的任何人？任何建议？

谢谢，

Mike

解决方案

从其他论坛，我了解到这是由于MS Update，而且一个很好的修复是从用户配置文件中的任何Temp子文件夹中简单地删除MSForms.exd文件。例如：

C：\Users\ [user.name] \AppData\Local\Temp\Excel8.0 C：\Users\ [user.name] \AppData \ Local\Temp\VBE\MSForms.exd

C：\Users\ [user。名称] \AppData\Local\Temp\Word8.0\MSForms.exd

当然应用程序（Excel， Word ...）必须关闭才能删除此文件。

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?

Thanks,

Mike

解决方案

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]\AppData\Local\Temp\Excel8.0\MSForms.exd

C:\Users\[user.name]\AppData\Local\Temp\VBE\MSForms.exd

C:\Users\[user.name]\AppData\Local\Temp\Word8.0\MSForms.exd

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

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