Infinite loop in a workbook open event

[MotroJena]

Yeah, it happened
The workbook file simply stops and crashes. Cannot access the VB editor.
I searched a solution in some places but the only I found is to hold the shift key while opening the workbook file but it didn't work in my excel 2010.

If someone can help........Thanks!

[MrShorty]

Have you tried holding control while opening to open Excel in safe mode (which should block all vba macros from running)? https://support.microsoft.com/en-us/...3-528af4f7ac72

[mgs73]

If you open Excel and disable events first before opening your spreadsheet, that should do it.

[MotroJena]

After. Hours pressing the control key. It finally worked once.

The tip is not open the file directly. open the excel shortcut application first, and then open the file in the recent tab.

[MotroJena]

Have you tried holding control while opening to open Excel in safe mode (which should block all vba macros from running)? https://support.microsoft.com/en-us/...3-528af4f7ac72

After. Hours pressing the control key. It finally worked once.

The tip is not open the file directly. open the excel shortcut application first, and then open the file in the recent tab.

[MotroJena]

If you open Excel and disable events first before opening your spreadsheet, that should do it.

It only worked with the file that you are opening. I think there is no way to disable macros to all workbooks.

[mgs73]

It only worked with the file that you are opening. I think there is no way to disable macros to all workbooks.

It doesn't disable macros, only event-driven ones, such as Workbook_Open

Please Login or Register  to view this content.

disables events for everything open in Excel until you set it back to True (or restart Excel).

[MotroJena]

It doesn't disable macros, only event-driven ones, such as Workbook_Open

Please Login or Register  to view this content.

disables events for everything open in Excel until you set it back to True (or restart Excel).

But where do I put this command?

The workbook events only work for the particular workbook, I guess

[mgs73]

But where do I put this command?

You can just type it into the Immediate Window (View - Immediate Window).