Dec 01 2020 09:08 PM
Hi, i have a sheet that i need like some advanced protection if thats a thing
the sheet has 3 type of users so to speak 1. read only 2. edit the protected sheet 3. people that designed it (me)
i want the number 2. group of people to have the password to the sheet to edit certain information. but then i have a few columns that I do not want touched by anyone
is there a way to lock down certain column/cells with a different password to the 'protect sheet' pass word, and remain locked regardless if the sheet is protected or not.
or any other security features that you think will help
thanks
Dec 02 2020 05:55 AM
See if this meets your needs: https://support.microsoft.com/en-us/office/lock-or-unlock-specific-areas-of-a-protected-worksheet-75...