.
I can't speak to your specific instances.
What I can relate is my system: Win 10/64 bit Excel 2007.
Occasionally I would experience workbook corruption, requiring moving the code to a new workbook in the same manner as you have done.
But, after a few weeks the corruption would occur again ... or ... I would experience various issues just trying to get the code to function.
It would work intermittently.
Several weeks ago I read online of a person who was using IOBIT software (defrag, anti-virus, anti-malware, system cleanup, etc.). That
individual had experienced numerous problems across his system. I too was running IOBIT ....
I've completely rid my system of IOBIT software. So far ... no problems. (saying prayers .. fingers crossed .. sacrificed a chicken to the
computer gremlins, etc.)
So far ... so good.
Now, even if you don't use IOBIT products, you might want to look at any commercial add-on software in your system.
(ps: thank you for admitting that a MAC has issues regardless of the source. I've grown very tired of listening to MAC owner who steadfastly
state their MAC never has issues.)