Forum Discussion
Unprotect sheets in a workbook
Hi all
I am in need of help, I have a workbook that was protected by another member of staff who has subsequently left. No one knows the password they used and I cant edit elements of the sheets.
I have tried the password breaker code as per the web but it just freezes the excel document. I have tried to duplicate and create a new sheet but my excel skills are not great and I cant seem to get the formulas right for the information to transfer any help would be greatly appreciated.
Kath
6 Replies
Select all cells in the sheet that is protected. Copy and Paste them into a new sheet.
Thank you for your help, I have tried this but the edits are not transferring to the sheets in the data transfer and drop downs. So back to square one with the locked sheets do you know of any other work arounds?
Kath
No sorry. Hacking is not my speciality 😞
