Column Level permissions in excel 365

%3CLINGO-SUB%20id%3D%22lingo-sub-1524084%22%20slang%3D%22en-US%22%3EColumn%20Level%20permissions%20in%20excel%20365%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1524084%22%20slang%3D%22en-US%22%3E%3CP%3EHello%20All%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ELet%20me%20get%20straight%20into%20the%20requirements.%20I%20have%20a%20file%20with%20multiple%20columns%20and%20i%20want%20to%20know%20if%20there%20is%20a%20way%20to%20hide%20few%20columns%20based%20on%20the%20user%20names.%20We%20use%20Office%20365.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ETHanks%20in%20advance.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ERegards%2C%3C%2FP%3E%3CP%3EShivakumar%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1524084%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1531546%22%20slang%3D%22en-US%22%3ERe%3A%20Column%20Level%20permissions%20in%20excel%20365%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1531546%22%20slang%3D%22en-US%22%3E%3CP%3EHi%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F95631%22%20target%3D%22_blank%22%3E%40Shivakumar%20N%20M%3C%2FA%3E%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EBest%20to%20my%20knowledge%20there%20is%20no%20such%20feature%20which%20can%20hide%2Flock%20the%20column%20based%20on%20user%20profile%2C%20however%20you%20can%20create%20the%20macro%20that%20can%20check%20the%20user%20profile%20and%20hide%2Flock%20the%20desired%20column.%26nbsp%3B%3C%2FP%3E%3CP%3EThis%20macro%20should%20be%20place%20workbook%20open.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%3ERegards%2C%20Faraz%20Shaikh%20%7C%20MCT%2C%20MIE%2C%20MOS%20Master%2C%20Excel%20Expert%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CEM%3E%3CFONT%20color%3D%22%23808080%22%3EIf%20you%20find%20the%20above%20solution%20resolved%20your%20query%20don't%20forget%20mark%20as%26nbsp%3B%3CSPAN%3EOfficial%2FBest%20Answer%26nbsp%3Bto%20help%20the%20other%20members%20find%20it%20more%3C%2FSPAN%3E%3C%2FFONT%3E%3C%2FEM%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E
Visitor

Hello All,

 

Let me get straight into the requirements. I have a file with multiple columns and i want to know if there is a way to hide few columns based on the user names. We use Office 365.

 

THanks in advance.

 

Regards,

Shivakumar

 

1 Reply

Hi @Shivakumar N M,

 

Best to my knowledge there is no such feature which can hide/lock the column based on user profile, however you can create the macro that can check the user profile and hide/lock the desired column. 

This macro should be place workbook open.

 

Regards, Faraz Shaikh | MCT, MIE, MOS Master, Excel Expert

If you find the above solution resolved your query don't forget mark as Official/Best Answer to help the other members find it more