Need to disable macros or view VBA code

[foxxfyre]

EDIT: Resolved - Disabled Trusted Documents

So... I've coded myself into a corner.

Upon opening my file, I have a userform that pops up requiring the user to make a selection before they can proceed to the excel file. I accidentally disabled the button that would close the userform and allow them to proceed to the excel file, and then I saved and closed the excel file. Now, when I open the file again, I cannot proceed past the userform AND excel won't let me open up the VBA editor to fix the mistake.

I cannot click on the X in the top right hand corner to close the userform either since I disabled it to prevent users from not filling out the mandatory userform.

Help! Is there a way to change my excel settings to disable all macros? I'm guessing that's one work around. If somebody has any suggestions, I'm all ears.

 

[Jonmo1]

Try holding down the SHIFT key while you open the file.

 

[foxxfyre]

That didn't work unfortunately.
BUT -
What did work was clicking "Disable Trusted Documents" under Macro Security.

Thanks so much for replying! What does holding down the Shift key do? Kill all macros?

 

[Jonmo1]

It's supposed to.

Trusted documents would override it though (apparrently)

 

[foxxfyre]

Good to know!
Thanks again.