locking cells and columns with out protecting the sheet

Copper Contributor

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 

 

1 Reply