How to stop VBA when opening workbook

[missingsc]

So I did something dumb and included a function that runs when the workbook opens, and in doing so introduced an infinite loop error upon opening the book. Since the loop never breaks, I can't get in to edit my code. I tried using the File > Open >hold shift and open file method, didn't work. I tried opening Excel in safe mode, also didn't work. The workbook still opens, the code runs, and it gets locked up.

Anyone know of another method that can halt code from being run when opening the workbook so that I can fix my blunder?

 

[Joe4]

How about temoporarily changing your VBA/Macros settings in Excel to one of the "Disable VBA macros..." options before trying to open the workbook?

 

[missingsc]

Phew, thank you! Fiddled with the trust center settings and allowed it to start up and do some edits, and backup a version now without my code.

Thank you!

 

[Joe4]

You are welcome.
Glad I was able to help!