Is VBA code causing Excel to crash RRS feed

  • Question

  • I have a small macro that I run on an excel spreadsheet, which saves the file once it is complete. When I try to then open the newly saved file, Excel spins and spins, and then craps out and becomes unresponsive. Does anyone have ideas of why this is happening and how I might fix it?
    Tuesday, February 27, 2018 2:47 PM

All replies

  • Can you show the VBA code for the section of code that fails?

    Try removing all Excel addins.  I have had problems with addins causing weird results.

    Tuesday, February 27, 2018 4:55 PM
  • Hi,

    As for your title (Is VBA code causing Excel to crash), it is probable. But this answer is of no effect. 
    Please provide code you have as for. Nothing can start without code.



    Tuesday, February 27, 2018 10:13 PM