Forum Discussion

Shivakumar N M's avatar
Shivakumar N M
Copper Contributor
Jul 15, 2020

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.

 

THanks in advance.

 

Regards,

Shivakumar

 

excel

1 Reply

  • ExcelExciting's avatar
    ExcelExciting
    MVP
    Jul 19, 2020

    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

Resources