Protected and Unprotected Sheets

Copper Contributor

I'm creating a chart and trying to customize a color combination for my theme. When I try to implement the color combination it says that I cannot due to the sheet being protected. I don't know why/how the sheet is protected. So, I'm wondering how to unprotect it without a password and why it's protected. 

2 Replies

Hi @jwcornell23 

 

Is it your workbook or somebody sent it to you?

Anyhow to unprotect the worksheet, right click on any sheet --> unprotect.

Or from review menu--> change group -->unprotect sheets

 

If it is protected for purpose, it might asks for a password.

 

 

You may want to check this discussion where a few solutions are offered:
https://techcommunity.microsoft.com/t5/excel/how-to-unprotect-the-excel-sheet-if-forgot-the-password...