title: How to unprotect an Excel workbook
body: <p>I have an Excel workbook that is password protected (the entire document, not just a sheet or set of sheets - you can't open the file without the password).  I know the password, so I am able to open it, but there is no obvious way to turn off the password protection.</p>
  
  <p>Specifically, I would like to do this in VBA, because eventually I want to be able to do this to multiple files using a loop.  I tried using:</p>
  
  <pre><code>ThisWorkbook.Unprotect(Password = "[password]")
  </code></pre>
  
  <p>but this does absolutely nothing.</p>