Unlocking A Protected Excel File
We had a Excel file that we needed to copy some of the cells to recreate a new proposal. The Excel file was locked, so we could view it but couldn’t copy anything.
I found the following link that helped me unlock the document.
https://www.ablebits.com/office-addins-blog/2016/02/10/protect-unprotect-excel-sheet-password/
I had to use the script and the VBA code to get a temporary password. This temp password allowed me to edit the document and do a Save As.
Let us know if this helps you…
Comments