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