无法单击ActiveX控件和窗体控件Excel 2010 [英] unable to click ActiveX control and form control Excel 2010

问题描述

我有一本工作簿，其中包含ActiveX控件按钮和窗体控件按钮，并且为这些控件分配了宏.这些控件在excel 2007中工作正常，但是当我在excel 2010中打开此工作簿时，无法单击这些控件.每当我单击任何按钮时，它就会进入设计模式.有没有可用的解决方案?

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??

推荐答案

Neha您的Excel设置阻止ActiveX按钮变为活动状态.这样做

Neha your Excel Setting are preventing the ActiveX Buttons to become Active. Do this

单击File Tab | Options.在打开的对话框中单击Trust Center，然后单击Trust Center Setting.转到ActiveX Setting并单击选项按钮Prompt Me before enabling all controls with minimal restrictions

Click On the File Tab | Options. Click on the Trust Center in the dialog box that opens and then click on Trust Center Setting. Go to ActiveX Setting and click on the option button Prompt Me before enabling all controls with minimal restrictions

关闭文件，然后重新打开.您将得到一个Yellow Popup Bar，要求您启用ActiveX.单击是"，您就完成了:)

Close the file and re-open it. You will get a Yellow Popup Bar asking you to enable the ActiveX. Click on yes and you are done :)

这篇关于无法单击ActiveX控件和窗体控件Excel 2010的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！