• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

VBA Error︰Pressed "Reset" button and then crashes Excel（Automation error - Exception occured）

S

smallxyz

Member
Hi all,

My Excel VBE behaves strangely recently.

Whenever I run VBA code in a module and encounter any Error, I will simply press the "RESET" button to re-inspect my code. Recently, after doing so, my Excel will hang for a moment and then prompt an alert window " Automation Error - Exception occured ". After clicking "OK" to continue. the whole Excel just crashes itself.

On the other hand, if the vba code runs smoothly without any error, my Excel just works perfectly as usual.

I have tested upon various sub-routines and notice that such crashing only occurs whenever I commit any coding error which is discovered and yellow-highlighted by VBE（but it shouldn't crash the whole Excel afterwards）. I have tried repair & also reinstall the Office but the issue still persists.

Clueless at the moment. Any one knows how to fix it?

Thanks in advance.
 
Yes. The core issue is that, after resetting, the whole Excel always crashes. And I need to restart the Excel & VBE to re-inspect the code. I hope to stop the crashing from happening at least.
 
Last edited by a moderator:
Does this happen with any workbook, or just a particular one? Also, which version of Excel are you using?
 
You must log in or register to reply here.
Back
Top