title: Excel 2013 worksheet activate
body: <p>I have an issue with activating a sheet from a user form, the same code works fine in Excel 2003 to Excel 2010, doesn't work with Excel 2013.</p>
  
  <p>This is how to simply reproduce the issue:</p>
  
  <p>Have a workbook with 2 worksheets in it, called <code>Sheet1</code> and <code>Sheet2</code> let's say, and on <code>Sheet1</code> 2 buttons:</p>
  
  <ol>
  <li><p>On click of <code>Button1</code> activates <code>Sheet2</code> worksheet using a <code>Macro1</code> with 1 line in it:</p>
  
  <pre><code>ThisWorkbook.Sheets("Sheet2").Select
  </code></pre>
  
  <p>and I can edit data from it fine.</p></li>
  <li><p>On click of <code>Button2</code> a <code>UserForm1</code> pops up and on click of <code>CommandButton1</code> call same Macro1 like this:</p>
  
  <pre><code>Unload Me
  Macro1
  </code></pre>
  
  <p>the <code>Sheet2</code> worksheet is activated, sort of, but if I edit data in it, it actually updates corresponding cells in Sheet1, if I click on <code>Sheet1</code> I can see data entered in there!</p></li>
  </ol>
  
  <p>Clicking back to <code>Sheet2</code> worksheet activates the <code>Sheet2</code> sheet properly.</p>
  
  <p>Has anyone seen such behaviour? If yes, are there any coding workarounds to properly activate <code>Sheet2</code>?</p>