无法单击Excel Active-X按钮 [英] Excel Active-X button cannot be clicked

问题描述

我有一个应该在excel中可以单击的按钮。当我尝试单击它时，没有任何反应。我注意到，如果单击并按住鼠标右下角，则会出现第二个按钮。过去曾经发生过这种情况，当我移动鼠标单击该按钮时，我可以单击并一切正常。

I have a button that should be clickable in excel. When I try to click it, nothing happens. I have noticed that if I click and hold the mouse in the lower right hand corner, a second button appears. This has happened in the past, and when I moved the mouse to click that button, I could click and everything would work.

但是这次，当我移动鼠标时，按钮消失了。因此，我无法使程序正常工作。

But this time, when I move the mouse, the button goes away. Thus, I cannot make the program work.

有人知道会发生什么吗？

Anyone know what could be going on?

更新：我尝试使用表单控件按钮执行此操作，但是出现以下错误：宏太复杂了。我还尝试了其他几个active-x控件，它们都做同样的事情-标签，复选框，下拉列表等。active-x控件的任何帮助将不胜感激。

UPDATE: I tried to do this with a form control button, but I get the error that the macro is too complex. I have also tried several other active-x controls and they all do the same thing - label, checkbox, dropdown list, etc... Any help with the active-x controls would be greatly appreciated.

推荐答案

我找到了解决该问题的方法。看来，如果您在其他监视器上打开了excel文件（我有3个屏幕：主屏幕+ 2个其他屏幕），则该按钮将显示这种古怪的行为。但是，如果您是主屏幕，它就可以正常工作。

I found a solution to the issue. It appears that if you have the excel file open on an additional monitor (I have 3 screens: main + 2 additional), the button gives this quirky behavior. However, if you are the main screen, it works just fine.

我在多台计算机上进行了尝试，并且在所有计算机上都相同。

I tried this on a multiple computers and it was the same on all.

不知道为什么可以，但是对我有用。

Not sure why that works, but it does for me.

这篇关于无法单击Excel Active-X按钮的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！