Excel cancelling Step-Into following Open.Workbook

[KDavidP1987]

Greetings all,

Version: Excel 2013

Having a frustrating little issue I don't know how to resolve. Whenever I enter Step Into mode of my Excel VBA script, it gets to a line that opens a workbook template for editing, and then instead of returning to step into it runs through the rest of the code.

​

Workbooks.Open FileName:="H:\Report Template.xlsx"

Is there a setting I need to adjust to stop it from doing this?

Sincerely,
Kris

 

[Fluff]

Have a look here https://www.mrexcel.com/forum/excel...ep-thru-macro-just-runs-without-stepping.html

 

[KDavidP1987]

Have a look here https://www.mrexcel.com/forum/excel...ep-thru-macro-just-runs-without-stepping.html

How in the heck did you find that so quickly! I have been scouring Google for solutions for hours and came across little effective results.

The replies in that post led me to a possible solution (reg edit) at:

http://www.contextures.com/excelvbatips.html#f8

You, sir, are a gentleman and a scholar! Thank you!!

Sincerely,
Kristopher

 

[Fluff]

Glad to help & thanks for the feedback