Forum Discussion
Column Level permissions in excel 365
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. ...
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