title: Worksheet protection set using ws.protect - but doesnt unprotect using the Menu (Review - Unprotect sheet)
body: <p>I have the following code to protect the sheets of a workbook in Excel 2007</p>
  
  <pre><code>Private Sub password_protectallsheets()
  For Each ws In Worksheets
  ws.protect Password = "edc1"
  Next
  End Sub
  </code></pre>
  
  <p>but when I try to unprotect the sheet using the password through the Excel 2007 Menu (review -> Unprotect sheet), it says the password you have supplied is not correct. </p>
  
  <p>Any help is hugely appreciated.</p>