I have an Excel workbook that has a lot of VBA. On first use of the workbook a macro is run that populates worksheets with data and formulae, formats worksheets, hides columns/rows. Since many of the worksheets are pw protected, there are also unprotect and protect steps. Use is made of screenupdating = FALSE; Calculation = xlCalculationManual and EnableEvents = False. It takes about 2 minutes to run the macro.
Out of curiosity I used the same workbook on a lower specification PC (a Dell laptop) and I really surprised to see it only took 45 seconds to run the macro.
This is not what I was expecting, particularly given the difference in specification of the PC's.
Main PC - Windows 10 64-bit; Intel i7-6700K @ 4Ghz; 32 GB RAM; Office 2010 32-bit;
Laptop - Windows 10 64-bit; Intel Celeron 900 @ 2Ghz; 2 GB RAM; Office 2007 32-bit;
I would really like to know why the VBA takes over twice to run on the much higher specification PC, and if there is anything I can do to improve the performance. Unfortunately, I cannot provide a copy of the workbook.
The only other application I have running is MS Edge.
Many thanks in anticipation
Also you missed about two other methods for speeding things up: https://blogs.office.com/2009/03/12/excel-vba-performance-coding-best-practices/