Macros are essentially bits of computer code, and historically they’ve been vehicles for malware. Microsoft Office documents containing built-in macros can be dangerous. Conflict with other programs or antivirus tool.
Microsoft Excel may crash due to any one or more reasons given below, Incompatible Add-Ins. Go to the Developer Tab and click “Macro Security” in the Code section of the Ribbon. To fix it, use the following steps (all credit to alulla at Ozgrid, whose directions I’ve lightly adapted for clarity): Open a new Excel workbook, not your crashing workbook. This is caused by a macro with a compile error.
Why does my Excel crash when running a macro? Why does my Excel crash when running a macro?.
