Forum Discussion
Excel Collaboration
Apply different passwords or permissions to separate ranges in workbooks in Excel
Please click on the link for detailed information.
A small example - step explanation.
Review tab
Changes
Users are allowed to edit areas
New area
This area relates to the cells: -> entire table, i.e. click on the character to the left of column A and above row 1. Password: Enter twice
Permissions
2 people who are allowed to edit the area (selected with the "Check names" help).
"Allow" permissions
Activate sheet protection including password
Take.
I hope you could understand.
I would be happy to know if I could help.
Nikolino
I know I don't know anything (Socrates)
* Kindly Mark and Vote this reply if it helps please, as it will be beneficial to more Community members reading here.