Forum Discussion

Copper Contributor

Nov 19, 2019

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...

excel

Excel Help

Kath790

Copper Contributor

Nov 19, 2019

Riny_van_Eekelen

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

Riny_van_Eekelen

Platinum Contributor

Nov 19, 2019

Kath790

No sorry. Hacking is not my speciality 😞

Kath790
Copper Contributor
Nov 19, 2019
Riny_van_Eekelen
Not a problem thanks for your help
- Wyn Hopkins
  MVP
  Nov 19, 2019
  Hi Kath790
  
  While I'm sure your intentions are honourable, we don't know you personally so we'd be wrong to break into this or show you how
  
  Sorry, I realise that is unhelpful
  
  Wyn
  - Kath790
    Copper Contributor
    Nov 19, 2019
    Wyn Hopkins
    
    Hi Wyn
    
    In relation to "breaking in", I have all the information on the sheet and can add to it I can just not amend the address on the invoice sheet (to our new company location) as that cell has been locked. My intentions are work and processing related if you are unable or unwilling to help that is fine and your prerogative however I have not asked if anyone has any other solutions as unlike with other password protected things their is no option to try and recover the password though other means of security. I am looking to see if their is a work around.
    
    Thanks