title: Excel VBA: Resetting spreadsheet count
body: <p>I have a excel VBA macro that dynamically generates and deletes spreadsheets based on user input. However, when I open the VBA IDE, it seems that although I am naming my spreadsheets in the subs that create/delete them, the overall count is still increasing.</p>
  
  <p>For example, depending on how far into execution my program is, under the "Microsoft Excel Objects" folder in my current project, the spreadsheets in the current workbook could look something like </p>
  
  <pre><code>Sheet101(Sheet3)
  Sheet103(Sheet2)
  Sheet104(Sheet1)
  </code></pre>
  
  <p>Or</p>
  
  <pre><code>Sheet81(Inputs)
  Sheet83(Date Adjustment Interpolation)
  Sheet84(Pricing)
  Sheet85(Comparison)
  </code></pre>
  
  <p>No matter if I delete the rest of them and add one, it still picks up where the last highest one left off.</p>
  
  <p>I don't know how many times this macro will be run and I'd feel a lot better about putting it out there if I could reset this annoying tally on the number of spreadsheets that have ever been generated, since I don't know for sure where excel will cut me off. Plus it's just annoying. </p>
  
  <p><strong>My Question:</strong></p>
  
  <p>I would like to know how to alter that spreadsheet number, or at least what the relevant object is for doing so.</p>
  
  <p>Thanks!</p>