title: Why can't my shared users use my script I have written into the Google Sheet?
body: <p>I have made a Google Sheet for job tracking. I wrote a script to hide certain rows once a field is entered into a specific cell.</p>
  <p>This is the script:</p>
  <pre><code>function myFunction() {
  
  }
  function onEdit(e) {
  var ss = SpreadsheetApp.getActiveSpreadsheet();
  var s = ss.getSheetByName(&quot;PRODUCTION TRACKER&quot;);      // Enter sheet name
  var row = s.getRange('AK:AK').getValues();            // Enter column letter that has 
  //the text &quot;hide&quot; and  &quot;unhide&quot;
  
  s.showRows(1, s.getMaxRows());
  for(var i=0; i&lt; row.length; i++){ if(row[i] == 'YES') { s.hideRows(i+1, 1); }   //Value to hide
   
  }}
  </code></pre>
  <p>It's very simple and works just fine for me. But why does it not work for my Shared users?  This script is something that is done automatically once a cell has a certain value, it's not a button or anything.</p>