title: Excel VBA Project has generated multiple Workbook objects
body: <p>I am responsible for a very large Excel 2010 spreadsheet with links to all sorts of external data sources including Bloomberg, 65 worksheets with vba modules and references to other vba add-ins.</p>
  
  <p>I have noticed that the VBA project has acquired multiple Workbook Objects.</p>
  
  <p>There's the standard ThisWorkbook.  However, a number of the worksheets have also been turned into Workbook objects by Excel, leaving the original worksheet as a copy of the previous one, minus the code.</p>
  
  <p>This doesn't appear to be a result of anyone's actions.  Indeed, I didn't think it possible to have more than one Workbook object!</p>
  
  <p>For example, I had one worksheet called wksInputs which has now been turned into a Workbook object, and the original wksInputs is now called wksInputs1.</p>
  
  <p><img src="https://i.stack.imgur.com/ERKKH.jpg" alt="example"></p>
  
  <p>I can't delete the wksInputs Workbook object.</p>
  
  <p>Please could someone help explain what's going on here, and how I might be able to resolve the problem...?</p>
  
  <p>Many thanks.</p>