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…

 

Comments

Leave a Reply

XHTML: You can use these tags: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong>