User Profile
TylerB82
Copper Contributor
Joined May 15, 2024
User Widgets
Recent Discussions
Protect Sheet with Different User Permissions
Hello, I am working on a workbook with a lot of information and a lot of users. I have a primary worksheet that I want to lock down, say that all the data is in the range of A1:G100 of Sheet1. I want to allow only a small portion of the users, call them Group A, to edit the contents of the primary worksheet. Adding rows, deleting rows, selecting cells and changing their values, working in the worksheet like there are no protections on it. Then I want the rest of the users, call them Group B, to be able to view the sheet and sort the data. Just sorting, not editing, adding, deleting, formatting, or anything other than sorting using filters. I've been struggling to come up with the right combination of Protect Sheet settings and Allow Edit Ranges and Permissions settings. If anyone could help with this, that would be great! Summary Group A: Edit cells, add/delete rows, do whatever they want with the worksheet Group B: Only sort/use filters, nothing else498Views0likes1Comment
Recent Blog Articles
No content to show