title: VBComponent refer to sheet by tab name
body: <pre><code>Set VBProj = ActiveWorkbook.VBProject
          Set VBComp = VBProj.VBComponents("Sheet10")
  </code></pre>
  
  <p>I have the code above. Currently Sheet10 is named as SummaryTab in the excel tab. I want to refer to the VBComponent using the name in the excel tab. Meaning that I want to use something like </p>
  
  <pre><code>Set VBComp = VBProj.VBComponents("SummaryTab")
  </code></pre>
  
  <p>However, the above code is giving me errors. how can I fix this?</p>