Jul 11 2020 06:49 PM
1. Set permission to ALLOW users in Group A to edit ranges (Column A) without a password
2. Set permission to ALLOW users in Group B to edit Column B without a password
3. Enabled the Protect Sheet
The result: Users in Group A and Group B can edit both Columns A and B which is not what I expected.
The result is still the same when I explicitly set the permission to DENY for Group B's users to edit Column A ranges without a password and Group A's users to edit Column B ranges.
Not quite sure why it's not working when I tested it in the desktop mode. Any thoughts or suggestions? Thank you
Jul 12 2020 04:07 AM
Hi @hs-prod
You need to set the range password for each group A & B then accordingly share the password to the groups
Hope the below steps might be helpful..
Note purple points are the important one..
Regards, Faraz Shaikh | MCT, MIE, MOS Master, Excel Expert
If you find the above solution resolved your query don't forget mark as Official Answer to help the other members find it more
Jul 16 2020 04:01 PM
@Faraz Shaikh Thank you for sharing and providing the screen shot along with the steps to configure the permissions. I was hoping that I could set the permissions solely by using the 'Allow' and 'Deny' rules without applying the passwords. Entering a password is not convenient and people tend to forget the password. So, I guess I'll have to find other ways. Thanks again.