为什么开发人员选项卡的“插入”菜单上的 ActiveX 控件被禁用？
我需要通过 VBA 以编程方式填写 Excel 2007 文件中工作表上的组合框的内容。从一些研究来看，这似乎无法通过“表单控件”来完成，我必须使用组合框的 ActiveX 版本。
一切都很好，除了在 Excel 中“开发人员”选项卡的“插入”菜单上，我可以添加的唯一启用的控件是表单版本。所有 ActiveX 控件都是灰色的，我不明白为什么。
我缺少什么？宏已启用。我已经检查了 ActiveX 安全设置并将其设置为启用所有内容。是否有一些必需的加载项默认情况下未安装？
I need to programatically fill in the contents of a combobox that is on a worksheet in my Excel 2007 file from VBA. From some researching it seems this cannot be done with a "Forms Control", I must use an ActiveX version of the combobox.
That's all fine, except on the Insert menu of the Developer Tab in Excel, the only controls that are enabled that I can add are the form versions. All of the ActiveX controls are greyed out and I can't figure out why.
What am I missing? Macros are enabled. I've checked ActiveX security settings and set it to enable everything. Is there some add-in necessary that isn't installed by default?
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（4）
我也有同样的问题。取消对工作簿的保护修复了它。
I had the same problem. Unprotecting the workbook fixed it.
检查视图对象的设置。
办公室按钮> Excel 选项 >高级>此工作簿的显示选项
干杯
安迪
http://www.pcreview.co.uk/forums/insert-illustrations-disabled-grayed-out-excel-2007-a-t3813221p2.html
Check the setting for View objects.
Office Button > Excel Options > Advanced > Display Options for this workbook
Cheers
Andy
http://www.pcreview.co.uk/forums/insert-illustrations-disabled-grayed-out-excel-2007-a-t3813221p2.html
您很可能尚未在工作表中选择单元格。
由于某种原因，如果您没有选择单元格，则 ActiveX 控件将显示为灰色（即使您将控件绘制到工作表上...）。
Most likely you have not yet selected a cell in your worksheet.
For some reason the ActiveX controls are greyed out if you don't have a cell selected (even though you draw the control onto the sheet...).
我仍然不知道为什么 ActiveX 控件被禁用，但我放弃了我的文件并创建了一个新文件。我的新文件中没有禁用这些控件。
I still have no idea why the ActiveX controls were disabled, but I abandoned my file and created a new one. The controls weren't disabled in my new file.