locking cells and columns with out protecting the sheet

%3CLINGO-SUB%20id%3D%22lingo-sub-1947189%22%20slang%3D%22en-US%22%3Elocking%20cells%20and%20columns%20with%20out%20protecting%20the%20sheet%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1947189%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%20i%20have%20a%20sheet%20that%20i%20need%20like%20some%20advanced%20protection%20if%20thats%20a%20thing%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Ethe%20sheet%20has%203%20type%20of%20users%20so%20to%20speak%201.%20read%20only%202.%20edit%20the%20protected%20sheet%203.%20people%20that%20designed%20it%20(me)%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Ei%20want%20the%20number%202.%20group%20of%20people%20to%20have%20the%20password%20to%20the%20sheet%20to%20edit%20certain%20information.%20but%20then%20i%20have%20a%20few%20columns%20that%20I%20do%20not%20want%20touched%20by%20anyone%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Eis%20there%20a%20way%20to%20lock%20down%20certain%20column%2Fcells%20with%20a%20different%20password%20to%20the%20'protect%20sheet'%20pass%20word%2C%20and%20remain%20locked%20regardless%20if%20the%20sheet%20is%20protected%20or%20not.%26nbsp%3B%3C%2FP%3E%3CP%3Eor%20any%20other%20security%20features%20that%20you%20think%20will%20help%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Ethanks%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1947189%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1948511%22%20slang%3D%22en-US%22%3ERe%3A%20locking%20cells%20and%20columns%20with%20out%20protecting%20the%20sheet%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1948511%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F287581%22%20target%3D%22_blank%22%3E%40Tullyk%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ESee%20if%20this%20meets%20your%20needs%3A%20%3CA%20href%3D%22https%3A%2F%2Fsupport.microsoft.com%2Fen-us%2Foffice%2Flock-or-unlock-specific-areas-of-a-protected-worksheet-75481b72-db8a-4267-8c43-042a5f2cd93a%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3Ehttps%3A%2F%2Fsupport.microsoft.com%2Fen-us%2Foffice%2Flock-or-unlock-specific-areas-of-a-protected-worksheet-75481b72-db8a-4267-8c43-042a5f2cd93a%3C%2FA%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional 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