Column Level permissions in excel 365

[Shivakumar N M]

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

[#2]

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