ertuta.blogg.se

In the VB Editor, save the project and then click Debug > Compile VBAProject.

Do not click "Enable Macros" - instead go to the Developer Tab and.Go to Trusted Documents and check the “Disable all Trusted Documents” box.Go to the Trusted Locations tab on the left and check the “Disable all Trusted Locations” box at the bottom.Click the bullet option entitled “Disable all macros with notification”.Go to the Developer Tab and click “Macro Security” in the Code section of the Ribbon.Open a new Excel workbook, not your crashing workbook.To fix it, use the following steps (all credit to alulla at Ozgrid, whose directions I've lightly adapted for clarity): This is caused by a macro with a compile error.