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的失败。我已经让他们进行了修复，并确保所有的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.
我把头发拔了出来，并在其他论坛上问过其他人是否有这个问题，以及他们做了什么来解决这个问题。提前谢谢。
3 个解决方案
#1
1
Could you please check in client system whether macros and active x controls are enabled in Trust center setting?
能否请您在客户端系统中确认信任中心设置中是否启用宏和活动x控件?
https://support.office.microsoft.com/en us/article/enable -或-禁用宏- -办公室-文件- 7 b4fdd2e - 174 f - 47 - e2 - 9611 - 9 - efe4f860b12?correlationid=fe6a4d24 f4d9 - 4 - c6b afa0 - 40 - d2828ad22e&ui=en us&rs=en us&ad=us
use above link if needed.
如果需要，请使用以上链接。
#2
0
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
#3
0
While saving the Excel document, save it as "Macro enabled workbook".xlsm
保存Excel文档时，将其保存为“启用宏的工作簿”.xlsm
#1
1
Could you please check in client system whether macros and active x controls are enabled in Trust center setting?
能否请您在客户端系统中确认信任中心设置中是否启用宏和活动x控件?
https://support.office.microsoft.com/en us/article/enable -或-禁用宏- -办公室-文件- 7 b4fdd2e - 174 f - 47 - e2 - 9611 - 9 - efe4f860b12?correlationid=fe6a4d24 f4d9 - 4 - c6b afa0 - 40 - d2828ad22e&ui=en us&rs=en us&ad=us
use above link if needed.
如果需要，请使用以上链接。
#2
0
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
#3
0
While saving the Excel document, save it as "Macro enabled workbook".xlsm
保存Excel文档时，将其保存为“启用宏的工作簿”.xlsm