Lock all rows in a sheet

Morning,

I need to be able to stop anyone other than the admins of the sheet from adding rows but I also need to give users "commenter" status because I want them to be able to use the comments. How can I make sure the only ones allowed to add rows are admins?

Thanks

Answers

  • Jason Duryea
    Jason Duryea ✭✭✭✭✭✭

    I would update the Sharing permissions on the Sheet accordingly. There is a new Commenter permission that can be set separate from Admin, Editor or Viewer.

  • I have every one that needs to look at the calendar as commenters (because they need to be able to comment). I found a little more out, they are using the form that I made for just the admins to add rows to the calendar. I edited the heading on the form but I need to be able to lock down that form so only the admins can use it. Is there a way to do that?