Lesson#122: Cell formatting in a protected sheet

Excel doesn’t accept to format cells which are protected, if they aren’t allowed for users. To format unprotected or protected cells users must allow before protecting a sheet. When you are protecting a sheet just see these options. The third

Tagged with:

Short Tips#0074: Protect only some cells in whole sheet

Tagged with:

Short Tips#0073: Make some cells unprotected when protecting a sheet

Tagged with:

Lesson#121: How to make some cells unprotected when protecting a sheet

OK, I am having a sheet here which calculate the age when birth date is provided. I need to protect the sheet before giving it to users. So none of them change the structure or formula. But I also need

Tagged with: ,