Need to edit a VBA script that automatically closes Excel

Alex,

You have to disable that macro somehow to be able to open that Excel file and get access to the macro code.

To do that, open a blank Excel workbook, then go to File >> Options >> Trust Center >> Trust Center Settings >> Macro Settings , or press Alt+T+M+S respectively.

Then make sure that the option (Disable all macros with notification) is selected.

In the same Trust Center dialog box select Trusted Documents, and click Clear button.

After that, find that Excel file and open it (Do not enable macros if you are prompted to do so), then press Alt+F11 to open the VBA editor, find the macro code and edit it as you want.