Forum Discussion
Excel - Customize protection to have multiple users with varied access and permission of a worksheet
Pavel Otych Thank you for the response. I was looking to know more about actual changes to data in a worksheet and giving permissions to some and not to others and giving some permissions to change certain cell content while others can change a different set/range of cell content - vs - security/firewall. Is is possible to give multiple users varied permissions to a worksheet with varied access to cells/ranges and what each user can change?
Marcy619 Oh, I see what you mean. Such a thing is not possible with AIP/Sensitivity labels - the permissions are set for the whole workbook, you cannot set different permissions for specific cells/ranges.
However, there is such a feature in Excel which allows access to specific ranges to specific domain users - https://support.office.com/en-us/article/lock-or-unlock-specific-areas-of-a-protected-worksheet-75481b72-db8a-4267-8c43-042a5f2cd93a I have no experience with that though.
Pavel Otych Sure do appreciate your help. Thank you. I am looking into your suggestion.