title: How to allow to run google script on a protected sheet (in a spreadsheet) [Can't use trigger and web app]
body: <p>I'm coding a script for a spreadsheet. This script creates a menu. 
  Then by choosing an option in this menu a function (which uses API) will run in order to filter some columns and hide others.</p>
  
  <p>The problem is: </p>
  
  <p>This sheet is protected (because shared with coworkers) but I want to allow people to run the script, which is impossible without the permission.</p>
  
  <hr>
  
  <p>I already looked at different solutions: </p>
  
  <ul>
  <li><p>Using a trigger: Doesn't work because a trigger can't correctly call a function which uses API (yes, my functions use API).</p></li>
  <li><p>Web App: When the script is run from the spreadsheet, the script is run as the current user, not the script editor. (the web app is efficient if the user uses the HTML page.)</p></li>
  <li><p>Remove protection -> run the function -> Re-add protection: Can't modify the protection without permission, which is logical.</p></li>
  <li><p>Add the current user in the list editor -> run the function -> Remove the current user from the list editor: Can't modify the editor list without permission, which is logical.</p></li>
  </ul>
  
  <hr>
  
  <p>How can I solve this problem?</p>