Forum Discussion
Protected worksheet's xml does not have <sheetProtection...
I have an excel workbook with protected sheets that were protected by a former employee who did not leave us any of the passwords. I used VB to determine the sheet number, changed the file extension ...
It's possible you may not have the correct sheet. To be certain, this is the part that would need to be located and deleted.
<sheetProtection algorithmName="SHA-512" hashValue="zRj94bi5MOmXIVXxMqVYdFoKt4zYwYyjyFg19pXAEGWq0GIgSBE4a56uQbXVg+iFP6g7fgAfFwBg/HB7oOTalw==" saltValue="V11hPS/OhVEUOIP1QcLZDA==" spinCount="100000" sheet="1" objects="1" scenarios="1"/>