ActiveX按钮重命名 [英] ActiveX Button Renaming

查看:133
本文介绍了ActiveX按钮重命名的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!

问题描述

首先,我知道ActiveX控件和2014年12月的MS Excel更新几乎无处不在。这似乎不同于常见症状,但可能是相关的。

First, I am aware of the nearly ubiquitous issue with ActiveX controls and the Dec 2014 MS Excel update. This appears to be different than the common symptoms, but it may be related.

症状:


  1. 打开现有的包含ActiveX控件的Excel工作表。

  1. Open an existing excel sheet that contains an ActiveX control.

单击该按钮,没有任何反应(宏不会启动)

Click the button and nothing happens (macro does not launch)

调查显示按钮名称已从 BtnMacroLaunch更改为 CommandButton3

Investigation shows that the button name has changed from "BtnMacroLaunch" to "CommandButton3"

我在其他用户计算机上打开文件并且按钮尚未重命名并且可以正常工作。

I open the file on other users machines and the button has NOT been renamed and it works correctly.

环境:


  • 具有此功能的工作表最后保存在其他用户的机器上,而不是我的机器上。当我使用ActiveX保存新的电子表格时,不会发生这种情况。

  • The sheets that have this were last saved on another users machines, not mine. When I save a new spreadsheet with an ActiveX, this does not happen.

如果其他用户打开并执行了我创建的工作表,则在保存该工作表时我再次打开它,按钮被重命名

If another users opens and executes a sheet I created, then saves that sheet, when I open it again, the button is renamed

自2014年12月中旬以来这一直是一个问题(大约)。 -这就是为什么我认为这与常见的ActiveX问题有关。

This has been a problem since mid Dec 2014 (approx). - which is why I think it is related to the common ActiveX issue.

我的大多数办公室同事(我认为除我以外的所有人)都拥有Dec Update在12月完成。我的更新被我们的IT部门无意中关闭了。我所有的同事也都删除了 forms .exd变通办法。

The majority of my office coworkers (I think everyone but me) had the Dec Update done in Dec. My updates were turned off inadvertently by our IT department. All my coworkers also did the delete "forms.exd" workaround.

我怀疑由于我的机器没有得到更新,这就是问题的原因。但是,昨天(1月19日),我终于修复了计算机,并应用了所有更新。然后,我做了删除 forms .exd的解决方法。不幸的是,这些按钮仍在重命名。

I suspected that since my machine had not gotten the updates, that was the cause of the issue. However, yesterday (Jan 19) I finally got my machine fixed and all the updates applied. I then did the the delete "forms.exd" workaround. Unfortunately, the buttons are still renaming.

这似乎与另一个按钮重命名问题并不完全相同。这不是在名称后面附加数字,而是完全重置名称。

This does not appear to be exactly the same as the other button rename problem. This is not appending a number to the back of a name, but resetting the name compeletly.

**


  • 问题:

**

如何阻止MS Excel重命名ActiveX按钮名称?另外,在我们的办公室内还有什么需要解决的问题吗?

How do is stop MS Excel from renaming the ActiveX button name? Additionally, is there something that needs to be addressed within our office?

推荐答案

更新

Update:

首先:让我正式说明问题:如何阻止MS Excel重命名ActiveX按钮名称?另外,在我们的办公室中还有什么需要解决的问题吗?

First: Let me formally state the question(s): How do is stop MS Excel from renaming the ActiveX button name? Additionally, is there something that needs to be addressed within our office?

第二:我的公司与Microsoft有支持协议。最终通过我们的内部IT流程获得帮助。

Second: My company has a support agreement with Microsoft. Finally wound through our internal IT process to get that help.

根据Microsoft的说法,该问题确实源于2014年12月的ActiveX更新。该更新日期为2014年12月9日。关联的KB是Office 2010的KB2553154和Office 2013的KB2726958。如果所有共享包含ActiveX控件的文档的计算机在上述KB更新方面的状态都不相同,则会出现此问题。因此,如果您有,而他们没有,那就有问题了。如果他们有,而您没有,那就有问题。我们已经在少数机器上对此进行了测试,并且使所有人在KB同步方面似乎都可以解决它。

According to Microsoft, the problem does stem from the December 2014 ActiveX update. The date of that update was 12/9/2014. The associated KBs are KB2553154 for office 2010 and KB2726958 for office 2013. If all the machines that are sharing documents that contain ActiveX controls are not in the same state regarding the KB updates mentioned above, then this problem will occur. So if you have it and they don't there is a problem. If they have it and you don't there is a problem. We have tested this on a handful of machines and getting everyone in sync regarding the KB seems to resolve it.

为什么在我获得更新后它没有解决在一月。显然,我在一月份没有获得所有更新。我们的IT部门通过Symantec Management Agent推送更新,现在正在调查该过程中的故障。

Why it didn't "resolve" when I got the updates in January. Evidently I did NOT get all the updates in January. Our IT department pushes updates via Symantec Management Agent, there is a breakdown in that process that they are now investigating.

第三:说我没有正确地问一个问题。尽管从技术上讲我对您的观察没有异议,但我同意JLee的观点:如果某人阅读了此问题描述并且不知道该问题,则无论如何也不需要该人的评论。此外,我还发现有趣的是,如果有人对发布礼节如此痴迷,会使用未定义的首字母缩写,例如 OP,因为我没有广泛使用论坛的内容,因此必须查找。

Third: To person that stating I didn't properly ask a question. While I technically have no qualms with your observation, I agree with JLee "If a person reads this problem description and doesn't know the question, that person's comments are not needed anyway". I additionally find it interesting that someone who is that obsessive about posting etiquette would use undefined acronyms such as "OP" - which I had to look up since I do not use forum's extensively.

这篇关于ActiveX按钮重命名的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!

查看全文
登录 关闭
扫码关注1秒登录
发送“验证码”获取 | 15天全站免登陆