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
I am attaching the file for your analysis.
many thanks
