title: Closing a workbook from an other one without stopping code
body: <p><strong>Issue :</strong> I am encountering the issue that if I try to close a workbook from an other one, the code stops running.</p>
  
  <p>This issue has been exposed in a few posts already but there doesn't seem to have a solution.</p>
  
  <p><strong>What I am trying to do :</strong></p>
  
  <ol>
  <li><p>I have a code in workbook WB1.xlsm called "Code1" which opens WB2 the following way <code>Workbooks.Open("WB2.xlsm").RunAutoMacros(xlAutoOpen)</code></p></li>
  <li><p>The Auto_Open code form WB2 is now running, I do my things in WB2 (copy data) and then the goal will be to paste those data in WB3 and close WB1 so I proceed as the following at the end of the Auto_Open code from WB2 before jumping into WB3: </p>
  
  <pre><code>For Each wbk In Workbooks
    If wbk.Name = "WB1.xlsm" Then
      'wbk.Activate
      'DoEvents
      'ActiveWorkbook.Close False
       wbk.Close False
      'Application.OnTime Now + TimeValue("00:00:01"), "wbk.Close"
    End If
  Next
  Workbooks.Open(PathTo_WB3).RunAutoMacros (xlAutoOpen)
  </code></pre>
  
  <p>The problem is that the code stops after closing WB1 ( above you can see different attempts to close it but they all fail...)</p></li>
  </ol>
  
  <p><strong>Question :</strong> Is it actually possible to close a workbook from an other one without seeing the code being stopped ?</p>