Forum Discussion
Macros suddenly run much slower
I had this very problem, where my 4-year-old Windows 10 laptop would process a macro I wrote in 2.5 minutes, vs. my new Windows 11 laptop taking 40+ minutes. The specs on my new laptop are much better, which left me baffled.
After not finding a solution online, I started to compare my Windows 10 Laptop settings with the Windows 11 and what I found was the Enable VBA macros (Not recommended; potentially dangerous code can run) were selected for my Windows 10 system but not 11, so after making my change, I went from a 40+ minute run time down to 5 or so minutes. Still not as good as my old Windows 10 laptop, but a lot better than 40+ minutes.
For those that are unsure where to find the setting navigate to the following:
File >> Options >> Trust Center Settings... >> Macro Settings >> Select the Enable VBA Macros (not recommended; potentially dangerous code can run) radio button >> OK >> OK
All Done!
Sounds good. I hope this works.
Would enable this option put the security at risk?
Patrick
If you're running your own macros, not really. It can be if you're running someone else's off the internet and don't understand what is running in your Excel. Also, scan attachments before downloading via email. Some of these can contain VBA.
- Yes. I agree.
Thanks.
