macros run slowly with "ActiveX Button", but run faster with "Form Control Button"

I have a problem of macros running very slowly, with something very strange!

When I click on ActiveX Button1, it takes for instance 15 seconds to accomplish the following macro :

Sub CommandButton1_click()   

   [my code] [no matter the content of the code, less or more complicated]

End Sub

The behavior is the same when I run CommandButton1_click() from VBEditor by pressing [F5] key!



Instead, in the same sheet, I created a "Form Controls" Button that launches the same macro "CommandButton1_click" and now it takes only 2 seconds to run the macro...



That can be a solution for some of you to improve the execution speed of macros.


Unfortunately, We can't apply this method for all slow macro.

I'd like to find the cause and a solution of:

Why the same macro runs slowly when I click on a "ActiveX" Button (or [F5]) and runs faster when I click on "Form Controls" Button ? very wierd