VBA debugging mode

[StringKing]

Hi,

Can anyone maybe help with a solution to the following:

I have compiled VBA code to complete certain tasks on a workbook. When stepping through the code (F8) it steps thorough correctly until i get to a "workbook.open" line. The debugger then runs automatically (similar to pressing F5), instead of just stepping through that line as one step (F8). It only stops when the code runs into an error or completes. I'm not pressing F5 at all during the entire process.

Is there a setting or something i can do to avoid the debugger from "running away" with the entire sub?

Thanks for your help!

 

[CharlesChuckieCharles]

is there code that runs automatically ( Autpen ) in the workbook you are opening?

 

[RoryA]

Have a look at Debra's tip here: http://blog.contextures.com/archives/2014/09/04/excel-vba-problem-with-step-into-f8/

 

[StringKing]

Hi CharlesChukieCharles,

No code running on Autpen.

Thanks RoryA, i'll give that solution a go.

 

[StringKing]

Thanks RoryA!
Debra's tip worked perfectly!

You guys rock! MREXCEL rocks! Everything is awesome