Worksheet_Activate does not run when opening workbook, even if I call sheet.Activate
<p>Currently I have created VBA code in worksheet 1 "Sheet1" as </p>

<pre><code>  Private Sub Worksheet_Activate ()
</code></pre>

<p>So every time I open the worksheet the VBA code will auto run. </p>

<p>But the problem I'm facing now is every time I open the Excel workbook, even though I added the codding in ThisWorkbook, </p>

<pre><code> Private Sub Workbook_Open()

     Worksheets("Sheet1").Activate

 End Sub
</code></pre>

<p>the worksheet will appear first but the VBA code won't auto run. Every time I need to shift another worksheet then shift back again, then only the VBA code will run, this is very annoying, is there any solution to fix this?</p>