Excel 2007中问题：pre-编程按钮突然不工作 [英] Excel 2007 Issue: Pre-programmed Buttons suddenly not working

问题描述

今天出了蓝色，一种形式，我为使用工作的公司，突然有一个问题与它的按钮。奇怪的是它仅影响到什么，我pretty肯定是的ActiveX命令按钮，而不是与其他形状或下拉菜单造成的问题。

问题。该按钮无反应。当你点击，他们不访问code，并通过形状菜单检查他们并选择视图code会导致他们打开开发商菜单，但与它们相关的不code。真正的大问题是，由于某种原因，他们似乎都已经开始在同一时间失败。在服务器上的版本不再有效（主副本），副本的用户使用（臭名昭著的摔东西），我使用的版本（这是我的本地计算机上）。

有没有办法把他们一个他们用正确的code重新关联，但不删除它们完全重新使它们还是有可能的人谁是有同样的问题，并想出了一个解决？

我会非常AP preciate任何建议或帮助 - 请注意：我99.9％肯定问题不是基于code

。

解决方案

该问题是由最近的Office更新所致。这里是修复上发布<一个href=\"http://excelmatters.com/2014/12/10/office-update-breaks-activex-controls/\">http://excelmatters.com/2014/12/10/office-update-breaks-activex-controls/

  

要解决它，做到这一点：

  
  

  
1. 关闭所有Office应用程序。

  
2. 请在Windows资源管理器搜索 - 做
     一定要包括隐藏和系统文件和文件夹 - 为* .exd文件
     （注：这不是* .EXE !!），并删除任何你发现。
     确保你得到这些：
     C：\\ Users \\用户名\\ AppData \\本地的\\ Temp \\ Excel8.0 \\ MSForms.exd
     C：\\ Users \\用户名\\ AppData \\本地的\\ Temp \\ VBE \\ MSForms.exd

  
3. 重新启动计算机（这并不总是必要的，但可能比更好的安全
     抱歉）

  
4. 重新启动您的Office应用程序并再次测试控制。

  

Today, out of the blue, a form that the company I work for uses, suddenly had an issue with it's buttons. Strangely enough it only is affecting what I'm pretty sure are the ActiveX Command Buttons and not causing a problem with the other shapes or drop downs.

The issue. The buttons are non-responsive. When you click, they don't access the code and checking them via the shapes menu and selecting "view code" causes them to open the developer menu, but not the code associated with them. The really big issue is that for some reason they ALL seem to have started failing at the same time. The version on the server no longer works (the primary copy), the copy the user uses (notorious for breaking things) and the version I use (which is on my local computer).

Is there a way to take them an re-associate them with the proper code, without deleting them completely re-making them or is there possibly someone who's had the same issue and figured out a fix?

I'd greatly appreciate any suggestions or help - please note: I'm 99.9% sure that the issue is not code based.

解决方案

The problem is caused by a recent Office update. Here is the fix posted on http://excelmatters.com/2014/12/10/office-update-breaks-activex-controls/

To fix it, do this:

1. Close all Office applications.
2. Do a search in Windows Explorer – make sure to include hidden and system files and folders – for *.exd files (note: that’s not *.exe !!) and delete any you find. Make sure you get these: C:\users\username\AppData\Local\Temp\Excel8.0\MSForms.exd C:\users\username\AppData\Local\Temp\VBE\MSForms.exd
3. Reboot the computer (this is not always necessary, but probably better safe than sorry)
4. Restart your Office apps and test the controls again.

这篇关于Excel 2007中问题：pre-编程按钮突然不工作的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！