Protect ranges with google apps script

by

Yes, you can accomplish this using the Protection class. You would first protect the whole sheet using var protection = sheet.protect(), then unprotect the ranges you want people to be able to edit using protection.setUnprotectedRanges([ranges]), where [ranges] is an array of range objects. You can read more about it in the Google Apps Script Class Protection documentation.

More Related Contents:

  1. Moving google apps script to v8 file upload stopped working from sidebar
  2. How to automatically import data from uploaded CSV or XLS file into Google Sheets
  3. How do I make a Sidebar display values from cells?
  4. Google Spreadsheet SCRIPT Check if edited cell is in a specific range
  5. button click is only working on Windows & not working on Android mobile sheet
  6. No permission to call msgBox in Google Apps Scripting
  7. Custom functions intermittently hang with “Error – Loading Data”
  8. How to define global variable in Google Apps Script
  9. Periodically refresh IMPORTXML() spreadsheet function
  10. Export (or print) with a google script new version of google spreadsheets to pdf file, using pdf options
  11. Format a Google Sheets cell in plaintext via Apps Script
  12. UiApp has been deprecated. Please use HtmlService instead
  13. Google app scripts: email a spreadsheet as excel
  14. Is there a way to keep two sheets synchronized?
  15. Selecting the last value of a column
  16. Google apps script to email google spreadsheet excel version [duplicate]
  17. How to get filtered values from Filter after using setColumnFilterCriteria?
  18. Measurement of execution time of built-in functions for Spreadsheet
  19. onEdit() doesn’t catch all changes
  20. Google Spreadheets Scripts: check if cell is empty
  21. Custom Functions with add-ons?
  22. How to prefill Google form checkboxes?
  23. Converting .xls to google spreadsheet in google apps script
  24. Use script in all spreadsheets
  25. Iterate over range, append string to each
  26. Can the google spreadsheet ‘query’ function be used in google apps script?
  27. How to pause App Scripts until spreadsheet finishes calculation
  28. Custom Functions and Recalculation
  29. How to create INDIRECT array string of multiple sheet references in Google Sheets?
  30. Can the google spreadsheet ‘query’ function be used in google apps script?

Leave a Comment