Here's the deal:
I'm trying to make a sheet where one person is allowed to edit everything and insert PDF files displaying employee vacation requests. A few other people need to be able to go in there and look at these PDF files but not change them at all.
There are also two rows that I have open for editing using "Allow Users to Edit Ranges" on row 11 and 28
I also used a blanket 1:65555 password protected unlock on all the cells, but also gave the primary user full permission on it without a password
The problems I am running in to are:
A) when the sheet is protected nobody can even view the PDF files and the primary user cannot insert new ones (just gets "cannot insert object")
Now I realize you can use the permissions options when you are protecting the sheet to enable ALL users to edit objects, but that's not what I want. I want her to be able to edit objects and nobody else.
And also I realize she can just unprotect the sheet, add a PDF, then protect it again. But I really want to avoid that scenario if at all possible.
Does anyone here know any way to set individual permissions for the ability to edit objects on a protected sheet so that only she will be able to edit and insert them, and also so I can set it so the other few people can view them but not edit them?
Please help![]()
Bookmarks