ActiveX button not triggering the VBA code.

Question

Split from this thread.

Hello,

I'm experiencing a similar issue.  Past excel (.xlsm) worksheets that have worked i.e. no changes to code, are no longer working.  When I attempt to the run the code directly from the VBA Code window, the code works.  It appears to be an issue with the ActiveX button not triggering the VBA code.  When I click on a button a smaller version of the button appears, but no other functions occur

Windows 10 Version 1803 (OS Build 17134.706)

Office Excel Version 1904 (Build 11601.20204 Click-to-Run)

While in Design Mode, right-clicking a button > CommandButton Object > Edit, the small button appears again and is the button that can be edited:

The little button is not there (i.e. clickable) at any other times.

Answer 1

I think I've found the thing that's causing the problem for me. It's a setting. In Display Settings, all three monitors are set to use the same Resolution ( 1920x1080). The 'Change the size of text, apps and other items' setting was at 125% for two of the monitors. For the third, the setting was 150%. When I moved the .xls between the screens, it was the third monitor where the problem presented. I changed the setting to 125% for the third monitor and now the buttons are working on that screen, as well as the other two i.e. it works consistently across all monitors. 

Thanks again for everyone's attention and support. Nice to get it resolved !

Steve

Answer 2

Hello Alex,

I discovered and resolved the issue!

I'm running a Surface Pro 4 connected to a Microsoft Dock that is connected to two monitors at 1680X1050 resolution.  Running the Excel files within the Surface Pro 4 window worked, but when I dragged the Excel window to the other monitors it seems like Excel was keeping the button focus in the locations of the buttons under the Surface Pro 4 resolution of 2736X1824 even through the visually the button display was relocated to the monitor resolution (hence the appearance of an extra button when the button was clicked, but no actions occurring?). 

Resolution:

I disconnected the monitors through Display Settings, restarted the Surface, reconnected the monitors through Display Settings and the files started to work on all screens/monitors.  Thanks for your time and energy in trying to help me resolve this issue.  This has to be a new one for the KB :)

Sincerely,

Darren Gock

Answer 3

Thanks for this Darren. This problem has been intermittent for me and hard to nail down a root cause. I would not have considered monitors. I'm running three monitors through a Kensington SD3600 - so it sounds like I could be experiencing similar. Currently the buttons are working, so I'm reluctant to change anything right now ... but if/when it next presents I will run your solution, see if it resolves and post back. Thanks again.