Issue with CommandButton Activex on Excel sheet

Question

question

RosarioDAgostino-4317 asked May 1, '22 RosarioDAgostino-4317 answered May 1, '22

Hi,

i am using office 2021, i created an excel sheet with macro which has CommandButtons on one of the sheets to activate the various macros i created.

On my PC I have never had any problems, on the other PCs with Office 2019 there are "strange" behaviors.

In particular, the following happens on one of the PCs:

just one click on the button, nothing happens. The associated macro is not called.
Repeated multiple clicks, the associated macro is called.

Has anyone had similar problems or knows of any reported bugs?

Thanks in advance

office-vba-dev

· 1

5 |1600 characters needed characters left characters exceeded

Attachments: Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Viorel-1 · May 01 at 04:36 PM

How did you determine that the macro was not started at all?

0 ·

Answer 1 · 2022-05-01T17:20:40.627Z

RosarioDAgostino-4317 answered May 1, '22

In debug, I inserted a breakpoint at the beginning of the macro.

5 |1600 characters needed characters left characters exceeded

Attachments: Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.