title: Accessing Public sub in ThisWorkbook module
body: <p>I have VBA code in the Sheet1 module and I want to call a sub procedure in that Sheet1 module when the workbook open so I do:</p>
  
  <pre><code>Private Sub Workbook_Open()
       Call MyMacro
  End Sub
  </code></pre>
  
  <p>behind SHeet1 I have</p>
  
  <pre><code>Public Sub MyMacro()
  ........
  End Sub
  </code></pre>
  
  <p>When the workbook opens I get the error:</p>
  
  <p>sub or function not defined "call GetReutersData"</p>
  
  <p>How can I call MyMacro from the Open() event?</p>
  
  <p>I need to have the MyMacro code in the sheet1 module just becuase that's the way it has to be. I cannot create a new module.</p>