title: How do I recover this VBA Project? Excel Error message: "Removed Part: /xl/vbaProject.bin part."
body: <p>I've seen related posts on other forums about this (see: <a href="http://www.mrexcel.com/forum/showthread.php?t=372534" rel="noreferrer">http://www.mrexcel.com/forum/showthread.php?t=372534</a>), but I've attempted everything that I've found with no success.</p>
  
  <p>Here's the situation:
  I have a .xlsm workbook (named 'PTPro.xlsm') that contains around 2000+ lines of VBA code in a Module and 6-7 large UserForms each with their own giant chunk of code.  Earlier today, I was working on the project and everything was going just fine.  I saved, closed, and opened the file about 20 times total throughout the process.  Never once did I receive an error message.  It should be noted (in case it's important) that I was saving directly to a flash drive from Excel.</p>
  
  <p>When I brought the project home this evening, I attempted to open it to make a quick change.  This is when I received the following series of error messages:</p>
  
  <ol>
  <li><p>"Excel found unreadable content in 'G:\PTPro\PTPro.xlsm'. Do you want to recover the contents of this workbook? If you trust the source of this workbook, click Yes."</p></li>
  <li><p>After clicking yes, a new dialog box opens with the following error message:</p></li>
  <li><p>"Excel was able to open the file by repairing or removing the unreadable content.  Removed Part: /xl/vbaProject.bin part.  (Visual Basic for Applications (VBA))"</p></li>
  <li><p>My only option at this stage is to click 'Close' which loads the workbook.</p></li>
  <li><p>When I hit Alt+F11 to view the VBA editor, the entire VBA project (modules, userforms, macros, etc.) is COMPLETELY GONE!!!</p></li>
  </ol>
  
  <p>I've followed all of the steps that I can find, including changing the Excel defaults to enable all macros and to tring to open the file on 4 different computers (both from the hard drive and from the flash drive).  The only thing that I can think of that I haven't tried yet is opening the file on the computer that I was working on today (which is a shared computer in a public computer lab, by the way).  This won't be an option until Monday.</p>
  
  <p>It should be noted that there are several sub-workbooks that include intermediate steps required by my application that were opened and closed frequently throughout the day, as well.  They are all working just fine.</p>
  
  <p>If you have ANY experience with this problem, or ANY ideas as to how I might recover the code I've written, I would be EXTREMELY grateful!!!</p>
  
  <p>THANK YOU!!!</p>