ActiveX Control not Working

Leonardo Fabián Grodek 26 Reputation points
2023-01-02T01:47:07.253+00:00

I added an ActiveX command button in Excel and assigned a macro/code to it in VBA. However, when I exit Design Mode, the control ignores any mouse click on it.
This happens only when I have the Excel window on a connected monitor. The button works fine when the Excel window is in the laptop screen.

The control does not appear greyed out or disabled.
I set the ActiveX settings to the most relaxed option, i.e. "Enable all controls without restrictions and without prompting..."
I tried with Safe mode checked and unchecked. No difference observed.
In Macro settings I selected "Enable VBA macros"

The button is supposed to just open a Form.

Any ideas? Why the screen on which I work on makes a difference?

Thank you.
Fabian

Microsoft 365 and Office | Development | Other
0 comments No comments
{count} votes

Accepted answer
  1. Valentin LEPAIN 80 Reputation points
    2023-04-18T08:42:38.4533333+00:00

    Hi Fabian, I had the same bug in my company, in the same case of you. After many tests and manipulations, i finaly find something working (the solution doesn't make sens, but it's working ...). Try to change the font size in the Display Parameters of Windows, for the screen that has the bug. In my case, it resolve the bug. Valentin

    1 person found this answer helpful.

0 additional answers

Sort by: Most helpful

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.