Forum Discussion

Dpaulhesk's avatar
Dpaulhesk
Copper Contributor
Mar 04, 2024

Lock Different Columns for Different People

We have a spreadsheet where people at various work levels can contribute comments. However, we need to restrict what people at lower work levels can see in the comments. Work Level 1 can only read their own notes. Work Level 2 should be able to read their and Level 1 comments. Work Level 3 should be able to read everything. I can easily group the columns depending on access level. How can I limit access to the Column Group levels by Work Level?

  • NikolinoDE's avatar
    NikolinoDE
    Gold Contributor

    Dpaulhesk 

    It is possible to achieve this type of access restriction in Excel through a combination of worksheet protection, column grouping, and perhaps some Visual Basic for Applications (VBA) scripting.

    But in order to propose a solution without having to constantly guess, you should provide some information, as well as a step-by-step description of your project.

    Attached is a link with some information in this forum (...and not just in this forum):

    more information.

     

    Thank you for your understanding and patience

     

Resources