25 Jul

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.

How to protect and unprotect Excel sheet with or without 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…

 

Leave a Reply

Your email address will not be published. Required fields are marked *