title: Excel VBA - Cannot Close New Workbook created using Workbook.Add
body: <p>I have the following code that creates a new workbook and populates it with some data. </p>
  
  <pre><code>Dim wb as Workbook
  Set wb = Workbooks.Add
  wb.Range("A1") = "Dummy Text" 'Some code that populates data
  wb.Activate 'wb.Activate or ThisWorkbook.Activate has no effect
  </code></pre>
  
  <p>The new workbook opens fine. I am able to minimise it, use the menus, etc. but am unable to click the close button. </p>
  
  <p>If I go back to the original workbook that has the macro and come back to the new workbook, I can close. </p>
  
  <p>How do I overcome this problem? Out of ideas unfortunately.</p>
  
  <p><strong>My desidred use case</strong></p>
  
  <p>Step 1 : User clicks a button -> A new workbook opens up with data</p>
  
  <p>Step 2 : User reads the information in the new workbook and decides to save / close</p>
  
  <p>But the close button in the new workbook won't work until the user goes back to the original workbook and comes again to the new workbook.</p>