title: "User-defined type not defined" for simple custom type
body: <p>In Excel 2007 I have the following very simple code in VBA:</p>
  
  <pre><code>Public Type specType
      sb As Long
  End Type
  
  
  Private Sub MyButton_Click()
      Dim spec As specType
  
      '...
  End Sub
  </code></pre>
  
  <p>When the button is clicked, i get a "User-defined type not defined" Error on the "Dim spec As specType" line... why? Do I have to move my user defined types to a special location?</p>