Forum Discussion

Tullyk's avatar
Tullyk
Copper Contributor
Dec 02, 2020

locking cells and columns with out protecting the sheet

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 

 

Resources