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...
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