title: Google Sheets - Use Script to Prevent Edits From Current User
body: <p>I have made a script that will copy a template sheet, and allow the user to enter customer data. The entry sheet should have protected ranges to prevent edits to parts not needed for entry, for example headers, labels, cells with formulas, etc. </p>
  
  <p>My issue is that it appears it is not possible for local script to remove edit permission for the current user, which is needed when the copy is made for a new entry. And I cannot figure out a way to "copy" permissions already set on the template. I have tried to set the script to remove by user email address, but the permissions will default to "can edit" for anyone that's not the administrator/owner.</p>
  
  <p>I have been thinking of using a bit of script in web app format to do the trick, as web apps can be set to run as owner, however I'm not sure this is possible to lock the specific sheet, by calling a function from a web app script. </p>
  
  <p>Any and all advise on this matter are extremely appreciated! </p>