06-10-2023, 09:28 AM
(06-10-2023, 08:45 AM)Koen G wrote: You are not allowed to view links. Register or Login to view.It is possible to protect certain ranges, would that help? I'm not sure if everyone can do that or only me as the owner of the file.
Yes but we may need to run some further tests on it.
I went ahead and locked the Comments Comparison sheet just now. I was able to set the permissions so that only you, as the workbook owner, and I can edit the spreadsheet or remove the protection. Then I tested if I could update a comment in my comments sheet and still have the Comments Comparison update and it did. Then I tested if I could continue adding formulas in the Comments Comparison and I could. All good so far. You should be able to do the same.
But we will need one of the other participants to try performing the same tests. If that person is (a) unable to directly edit any cells in the Comments Comparison and (b) able to add comments in their individual comments sheet and still have the Comments Comparison auto update, then protecting the sheet will work as a solution.