title: Focus back to Excel once email has been created with VBA
body: <p>I have a VBA macro which does the following:</p>
  
  <ol>
  <li>Creates a report, saves it to main directory. Closes the report</li>
  <li>Creates various emails, attaches the report to each (doesn't send the email)</li>
  <li>Msgbox shows up showing that process is finished</li>
  </ol>
  
  <p>The thing is that, once the whole process is finished, I want the user to know it is done, but this code doesn't return the focus to excel (which I hoped would be the problem)</p>
  
  <pre><code>Windows(the_current_window).Activate
  Worksheets(currentQuoteSheet).Select
  </code></pre>
  
  <p>The last email created is what stays on screen. The msgbox doesn't come up, only if I click on excel icon on the menu bar it does. So users are there just waiting to finish (when it has, in fact  :(  )</p>
  
  <p>Any ideas how to make sure the msgbox shows up after last email is created without users having to click on excel?</p>