Forum Discussion

Kath790's avatar
Kath790
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
Wyn Hopkins's avatar
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's avatar
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 

Resources