title: VBA Run / do something when the file start up
body: <p>As an alternative to global variable, I am trying to read the last value I worked on at start up. I read this: <a href="https://stackoverflow.com/questions/13946645/excel-vba-workbook-open">Excel VBA: Workbook_Open</a>, and <a href="http://www.ozgrid.com/VBA/auto-run-macros.htm" rel="nofollow noreferrer">this</a>.  and tried to implement my own. But it is not doing anything at the moment.</p>
  
  <pre><code>Private Sub Workbook_Open()
  
      MsgBox "Testing.."
  
  End Sub
  </code></pre>
  
  <p>I noticed when I paste the following code into my project, it is in the <code>general</code>, instead of in the <code>worksheet</code>. I don't know if that's the problem, I already have a method that listen to changed in my <code>worksheet</code>.</p>
  
  <p>Edit: This is the screen I am at right now...
  <img src="https://i.stack.imgur.com/M9fPg.jpg" alt="enter image description here"></p>
  
  <p>Edit: I see what happened. ****I must open view > Project Exloper > This Workbook **** in order to click on <code>ThisWorkbook</code>. Thank you for your help!</p>