Forum Discussion
jwcornell23
Jun 08, 2022Copper Contributor
Protected and Unprotected Sheets
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.
- Patrick2788Silver ContributorYou 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/m-p/1574559/highlight/true - Jihad Al-JaradySteel Contributor
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.