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...
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 😞
Not a problem thanks for your help
