I worked around this problem by transfering the macros to a clean new workbook. Everything runs now.
But, I seem to recall I had the same problem with Windows Excel VBA years ago in a spreadsheet that used a lot of plotting. After frequent intense debugging sessions the macros wouldn't run either.
So is macro fatigue something that is common knowledge?