Hi there,
I have some VBA macros that I have been using for years. I'm running Office 365 on a MacBook Pro (2.7 GHz Quad-Core Intel Core i7) and Excel version 16.36 (I'm on the "Fast" updates program, so it gets updated 2-3 times per week).

I've noticed in the last 4-6 weeks that all my macros are suddenly running extremely slowly. What I mean by that is there can be a delay of 15-20 seconds where absolutely nothing happens before the macro performs its tasks. In addition, with another macro that uses a MsgBox to display a warning, the MsgBox just sits on the screen for the whole 15-20 seconds, until the macro completes.

I have Windows 10 running on my Mac through Parallels Desktop, so I thought I would try running them on the same version of Excel in Windows and, amazingly, they performed instantly, with no delay. None of these macros used to behave in this way on my Mac. It's like Microsoft has put a hidden delay into them on a Mac.

I haven't bothered copying any of the code, because I don't think it has anything to do with the macros themselves.

Has anyone else noticed this? Is this a known issue? Is there a solution to it?

Thanks
Stephen