MS Excel VBA for when you are getting spurious & seemingly random ‘Code has been interrupted’

You have no breakpoints but you get ‘Code has been interrupted’


  1. Press “Debug” button in the popup.
  2. Press Ctrl+Pause|Break twice.
  3. Hit the play button to continue.
  4. Save the file after completion.

Yes it is a little mad… but that should fix it..