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

Hi Alex,

Just sent a file via the shared link.   For your reference:

Windows Version 10: Version 1803 (OS Build 17134.706)

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

Thanks for your help,

Darren

Answer 4

Hi Darren,

Thanks so much for your patience. I received your file.

I still cannot reproduce this with the file you shared. I recored a video, you can check it here: Private Message.

As you can see in the video, I am using the Windows version: 1809 (OS Build 17763.437). I think that's the main different between our environment. Can you check for the Windows Update?

Regards,

Alex

Answer 5

Hi Darren,

Thanks so much for sharing it with us. It did not come across me that it would relate to the extra screen. Glad to hear that you have found the solution. 

Thanks,

Alex