ActiveX 控件更改为图片 (Excel/VBA)
声明：本页面是StackOverFlow热门问题的中英对照翻译，遵循CC BY-SA 4.0协议，如果您需要使用它，必须同样遵循CC BY-SA许可，注明原文地址和作者信息，同时你必须将它归于原作者（不是我）：StackOverFlow
原文地址: http://stackoverflow.com/questions/28419727/
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
ActiveX controls changing to pictures (Excel/VBA)
提问by Darw1n34
My company creates workbooks for clients that contain ActiveX controls (in most cases we need the extra functionality as compared to Form Controls). When we create them, they work fine on our end, but when we zip them up and send them to our clients, they open the WB and the ActiveX controls are no longer ActiveX controls, if you right click it, it behaves like a picture.
我的公司为包含 ActiveX 控件的客户创建工作簿（在大多数情况下，与表单控件相比，我们需要额外的功能）。当我们创建它们时，它们在我们端工作正常，但是当我们将它们压缩并发送给我们的客户时，它们打开 WB 并且 ActiveX 控件不再是 ActiveX 控件，如果您右键单击它，它的行为就像一张图片.
I feel like this is due to the MS ActiveX debacle. I have had them run the Fix It and making sure all the MS Office components were closed, and had them reboot, but still nothing.
我觉得这是由于 MS ActiveX 崩溃造成的。我让他们运行 Fix It 并确保关闭所有 MS Office 组件，并让他们重新启动，但仍然没有。
I am pulling out my hair, and have asked on other forums if anyone else has had this issue, and what they have done to fix it. Thanks in advance.
我正在拔头发，并在其他论坛上询问是否有其他人遇到过这个问题，以及他们做了什么来解决这个问题。提前致谢。
回答by Nagendra
Could you please check in client system whether macros and active x controls are enabled in Trust center setting?
您能否在客户端系统中检查是否在信任中心设置中启用了宏和活动 x 控件？
use above link if needed.
如果需要，请使用上面的链接。
回答by bmende
Try closing excel and deleting the .EXD files from your computer.
尝试关闭 excel 并从您的计算机中删除 .EXD 文件。
Source: http://www.mrexcel.com/forum/excel-questions/296750-command-button-turned-into-image.html
来源：http: //www.mrexcel.com/forum/excel-questions/296750-command-button-turned-into-image.html
回答by Chidiebere Okogwu
While saving the Excel document, save it as "Macro enabled workbook".xlsm
保存 Excel 文档时，将其另存为“启用宏的工作簿”.xlsm
