Forum Discussion

Lorenzo Kim's avatar
Lorenzo Kim
Bronze Contributor
Aug 13, 2018

Excel stopped working

The SUB below is working fine when [X] is clicked BUT not when the SAVE Icon is.. a prompt "Excel stopped working" always pops up when saving but when ignored, it continued  saving anyway.  What cou...
excel
Macros and VBA
Kenton Smith's avatar
Kenton Smith
Copper Contributor
Aug 14, 2018

"On Error Resume Next" is poor coding and should be avoided as much as possible.

Remove your "On Error Resume Next" statement from your code, and get the proper error. Now you can deal with these errors or manage them via err.number. 

  • Lorenzo Kim's avatar
    Lorenzo Kim
    Bronze Contributor
    Aug 14, 2018

    Mr. Smith

    thank you for your reply.

    I deleted the "on error resume next" -

    still the same prompt popped = [Microsoft Excel stopped working]..

    I ignored it and it saved the file anyway.

    no error number was quoted.

    what could be causing the prompt?

    many thanks

     

     

     

    • Kenton Smith's avatar
      Kenton Smith
      Copper Contributor
      Aug 14, 2018

      Also remove "Application.DisplayAlerts = False"

      • Lorenzo Kim's avatar
        Lorenzo Kim
        Bronze Contributor
        Aug 14, 2018

        Mr. Smith

        I remove "Application.DisplayAlerts = False"

        still, the same thing happened.

        no error number appeared just the prompt "Excel Stopped Working"

        Would you mind testing it on your side?

        many thanks 

Resources