title: GAS: Range Protection?
body: <p>I've looked everywhere and it seems that GAS hasn't caught up with Google Spreadsheet. Is there a brute force method  for setting protection on certain ranges in a sheet..? (And making a protected sheet with all the formulas and referring to them won't help me.)</p>
  
  <p>I found this through google: <a href="https://code.google.com/p/google-apps-script-issues/issues/detail?id=1721" rel="nofollow">https://code.google.com/p/google-apps-script-issues/issues/detail?id=1721</a></p>
  
  <p>I even commented at the bottom. (More of a complaint than anything useful.) But the guy above me there posted this code:</p>
  
  <pre><code>//Function to Protect Target Sheet
  function ProtectTargetSheet() {
  
        //Enter ID for each Worksheet
        var IDs = ["Sheeet_1", "Sheet_2"]
  
        //Enter Page to protect, in order of WorkSheets
        var Sheet_names = ["Page_1", "Page_2"]
  
        //For each sheet in the array
        for ( i = 0; i &lt; IDs.length; i ++) {
  
          //id of sheet
          var sheet = IDs[i]
  
          //activate dedicated sheet
          var ActiveSheet = SpreadsheetApp.openById(sheet)
  
          //Find last row and column for each sheet
          var LastRow = ActiveSheet.getSheetByName(Sheet_names[i]).getLastRow();
          var LastCol = ActiveSheet.getSheetByName(Sheet_names[i]).getLastColumn();
  
          //Name of protectSheet
          var Name = "Protect_Sheet";
  
          //Range for Protection
          var Named_Range = ActiveSheet.getSheetByName(Sheet_names[i]).getRange(1, 1, LastRow, LastCol);
  
          //Impletment Protect Range
          var protected_Range = ActiveSheet.setNamedRange(Name, Named_Range);
        }
  }
  </code></pre>
  
  <p>I don't see how this can work to give protection to a range when shared. It seems that it would just create a Named Range. He does say to set the permissions manually first. But I can't figure what exactly he meant.</p>
  
  <p>Anyways, I was hoping that someone had found a way by now to do this until Google syncs GAS with its counterpart.</p>
  
  <p>My wish is to, through 100% code, select a range in a sheet, within a spreadsheet, and make it so that when I share this whole spreadsheet to a person, that he or she can't edit that range. There will be other parts in that sheet that they have to be able to edit. Just not that range. It is easy to do this manually, but when having to create 100s of spreadsheets, it would be help to be able to do this through GAS.</p>
  
  <p>Thanks.</p>