Lock Different Columns for Different People

Copper Contributor

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?

1 Reply


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