title: Excel, Compile VBAProject - change the order of the compilation of modules
body: <p>Lets suppose that we are in the Visual Basic Editor, in Excel 2007. We create one module, named <code>modGlass</code>:</p>
  
  <pre><code>Sub VolatileGlass()
      Dim Glass As shiny_surface
  
  End Sub
  </code></pre>
  
  <p>and then we create a second module, named <code>modMetal</code>:</p>
  
  <pre><code>Sub durableMetal()
      Dim metal As metal_compound
  
  End Sub
  </code></pre>
  
  <p><img src="https://i.stack.imgur.com/Fngtu.png" alt="enter image description here"></p>
  
  <p>Subs in both modules contain the error: <code>"User-defined type not defined."</code></p>
  
  <p>When I compile the project by using the <em>Debug: Compile VBAProject</em> menu entry, the <code>modGlass</code> module always compiles first. If I:</p>
  
  <ul>
  <li>double click on the <code>modMetal</code> module and compile (it?) or</li>
  <li>rename <code>modMetal</code> to <code>amodMetal</code> (so that the metal module is now first in the module tree hierarchy of the project)</li>
  </ul>
  
  <p>still, the <code>modGlass</code> module is compiled first.</p>
  
  <p>The question: if I have a project with multiple modules in VBE, is there a way to specify, in what sequence will the modules be compiled?</p>
  
  <p>I don't really need this feature, but I'm just curious if there is some quick way to do it. I'm using Excel 2007.</p>