title: Create global variables
body: <p>Bit of a newbie to VBA, sorry</p>
  
  <p>I need to create some variables that are available throughout my workbook, but I can't seem to figure it out. I've read in previous questions where some people have suggested create a separate dim for this?</p>
  
  <p>When the workbook opens I need to set some variables equal to certain cells in a worksheet, these variables need to be called from dims in others worksheets.</p>
  
  <p>So far I have tried to use </p>
  
  <p>Workbook_Open()</p>
  
  <p>In the 'ThisWorkbook' code area but to no avail. </p>
  
  <p>Any tips?</p>
  
  <p>Reagards</p>
  
  <p>EDIT ----</p>
  
  <p>I have tried with the following:</p>
  
  <p>In 'ThisWorkbook'</p>
  
  <pre><code>Public wsDrawings As String
  Public Sub Workbook_Open()
       wsDrawings = "Hello"
  End Sub
  </code></pre>
  
  <p>And in Sheet1</p>
  
  <pre><code>Private Sub CommandButton1_Click()
      MsgBox wsDrawings
  End Sub
  </code></pre>
  
  <p>I do not get an error, but the message box is empty.</p>