Edit Code that runs on Workbook open and closes active workbook

[jonesalexr]

Hello,

I have made a code that will run when opened via task scheduler. I have trusted the workbook so it doesnt prompt me for macro. My workbook open event calls the macro. After macro is complete, it closes the workbook containing the VBA. Without blocking macro's or untrusting the folder, how do I edit the code in the VBA editor?

 

[brian.wethington]

The simplest way I can think of is:
1)before you open the file turn off events

Sub DisableTheEvents()
Application.EnableEvents = False
End Sub

2) open file and make your changes
3) Ensure you turn on your events again

Sub EnableTheEvents()
Application.EnableEvents = True
End Sub

 

[RoryA]

Hold down the shift key while opening the workbook.

 

[brian.wethington]

Hold down the shift key while opening the workbook.

Really? Man, I have made it so much harder in the past.