Forum Discussion
DrSph
Apr 15, 2023Copper Contributor
Excel shutdown when a macro is running
Hello, I don't understand why but since 3 days my excel file shutdown when I trying to run a macro which running without any problem before. I've seen différents other problems like I can't write a v...
szjohnk
Dec 14, 2023Copper Contributor
Hello all. I experienced the same problem when working Excel with VBA. Excel shuts down when I tried running a VBA. I checked that the Visual Basic Editer cannot shows the codes and the code window gone. After reworking for many times, I realised that it happened during I worked under VPN. I have to reboot the PC and make a new workbook to eliminate the problem. Once a workbook is crushed when running VBA, we cannot update it to recover from randomly shut down problem. We have to build a new workbook and input all data and VBA once again from the beginning.