The title says it all. This is not about tips to make my code run faster. I routinely run a "Turn Stuff Off" before and a "Turn Stuff On" after the main code.
The question is: When I run the same code from F5 in the VBE vs All Ways to CALL the code, why are all the other ways 5 times slower?
F5 = 5 sec
vs
form button = 26 sec
activeX = 26 sec
ctrl + sft + Q = 26 sec
selecting macro from the macro dialog box = 26 flipping sec
The question is: When I run the same code from F5 in the VBE vs All Ways to CALL the code, why are all the other ways 5 times slower?
F5 = 5 sec
vs
form button = 26 sec
activeX = 26 sec
ctrl + sft + Q = 26 sec
selecting macro from the macro dialog box = 26 flipping sec