title: Excel 2016 VBA Workbooks.Open Loses Debug Step Mode.. revisited
body: <p>Similar to a previous thread*, when I step into a VBA sub in Excel 2016 and then step into the statement:</p>
  
  <p>Workbooks.Open Filename:= "C:\file2"</p>
  
  <p>the file opens okay but on return the remainder of the sub just executes to the end (I lose step into mode).</p>
  
  <p>I’m running Windows 10 on a 64 bit machine, and a 32 bit version of Office professional Plus 2016</p>
  
  <p>*The same issue is described in following link: 
  <a href="https://stackoverflow.com/questions/30330920/excel-2013-vba-workbooks-open-loses-debug-step-mode">Excel 2013 VBA Workbooks.Open Loses Debug Step Mode?</a>
  but the 'ideal' solution is to add a breakpoint after the workbooks.open line.This does not work in Excel 2016 - the routine stops but on the first press of F8 the routine completes to end.</p>
  
  <p>The same issue is describe here:</p>
  
  <p><a href="http://blog.contextures.com/archives/2014/09/04/excel-vba-problem-with-step-into-f8/" rel="nofollow noreferrer">http://blog.contextures.com/archives/2014/09/04/excel-vba-problem-with-step-into-f8/</a>
  but the solution (requiring changes to the registry) applies to earlier versions of Excel and does not work for Windows 10/Office 2016.</p>
  
  <p>This is a frustrating issue preventing effective debugging. Microsoft Pro support have directed me to the Excel fora. So here we are.. :)</p>
  
  <p>Any ideas to fix warmly welcomed.</p>