Using 'allow users to edit range,' I have set a range-2:1000, and entered a range password. I have listed 3 users to have access without entering the range password via Permissions>Security. I then protect the sheet and enter a password for users not part of this list must enter to edit.
However, when a user opens the workbook he/she can edit that sheet-and is not part of the security permission list.
What I'm looking for:
User opens the workbook of x number of worksheets. Each worksheet uses range protection to grant only certain people edit access to that sheet.
Do i also need to protect the workbook, in addition to worksheet when using range permissions?
Bookmarks