Jan 16 2024 10:26 AM
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 to .zip, extracted the sheet's xml, opened the xml with notepad++, and searched for sheetProtection. It is not in there. I searched for just protection and algorithm but they are not int there either. I also tried open with just notepad, same results. I checked the other 3 protected sheets in the workbook, none of them have sheetProtection either. In the workbook, all the sheets say the workbook protection is off, but I checked the workbook xml for workbookProtection anyway. It is not there.
There are macros in the workbook for other worksheets within the workbook. I was able to copy those worksheets from another workbook into this one.
Is there some other place the passwords would be hidden or some other property? Is there some other way to remove/learn the worksheet passwords?
Jan 16 2024 10:41 AM
Jan 16 2024 10:55 AM - edited Jan 16 2024 10:56 AM
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"/>