title: Running a macro in the background
body: <p>When running a macro in Excel, Excel focus its attention fully on the macro to complete and you cannot do anything in the workbook but wait. Is it possible to run a macro (in the background) in a workbook while working in the workbook as well?</p>
  
  <p>I tried to run the below code with <code>DoEvents</code> but it is not giving me what i want. Excel still hangs when the code is running,</p>
  
  <p><code>While (True)
  For i = 1 To 500000
      Cells(i, 1).Value = 1
  DoEvents
  Next i
  Wend</code></p>