vba 无法单击 ActiveX 控件和表单控件 Excel 2010
声明：本页面是StackOverFlow热门问题的中英对照翻译，遵循CC BY-SA 4.0协议，如果您需要使用它，必须同样遵循CC BY-SA许可，注明原文地址和作者信息，同时你必须将它归于原作者（不是我）：StackOverFlow
原文地址: http://stackoverflow.com/questions/10529269/
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
unable to click ActiveX control and form control Excel 2010
提问by CuriousCase
I have a workbook,which contains ActiveX control button and form control button and macros are assigned to those controls. these controls are working fine in excel 2007 but when I open this workbook in excel 2010, I am unable to click on those controls. Whenever I click on any button,it goes in design mode. Is there any solution available??
我有一个工作簿，其中包含 ActiveX 控件按钮和表单控件按钮，并为这些控件分配了宏。这些控件在 excel 2007 中工作正常，但是当我在 excel 2010 中打开此工作簿时，我无法单击这些控件。每当我单击任何按钮时，它都会进入设计模式。有什么解决办法吗？？
回答by Siddharth Rout
Neha your Excel Setting are preventing the ActiveX Buttons to become Active. Do this
您的 Excel 设置阻止 ActiveX 按钮变为活动状态。做这个
Click On the File Tab| Options. Click on the Trust Centerin the dialog box that opens and then click on Trust Center Setting. Go to ActiveX Settingand click on the option button Prompt Me before enabling all controls with minimal restrictions
点击File Tab| Options. 点击Trust Center在打开的对话框，然后点击Trust Center Setting。转到ActiveX Setting并单击选项按钮Prompt Me before enabling all controls with minimal restrictions
Close the file and re-open it. You will get a Yellow Popup Barasking you to enable the ActiveX. Click on yes and you are done :)
关闭文件并重新打开它。您将收到一个Yellow Popup Bar要求您启用 ActiveX 的提示。点击是，你就完成了:)
