Forum Discussion
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...
"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.
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
Also remove "Application.DisplayAlerts = False"
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
