Google apps script error: “You do not have permission to call protect” [duplicate]

by

Custom function run anonymously so the implicit consequence is that they can not do anything that requires authorization.

Changing a range protection requires an authorization , that’s why you can’t use it and get the message you get…

Same situation for getEffectiveUser(), it requires an authorization too.

Reference in docs :

Unlike most other types of Apps Scripts, custom functions never ask
users to authorize access to personal data. Consequently, they can
only call services that do not have access to personal data

More Related Contents:

  1. No permission to call msgBox in Google Apps Scripting
  2. You do not have permission to call openById
  3. Custom Functions with add-ons?
  4. Is it possible to ‘prefill’ a google form using data from a google spreadsheet?
  5. How to protect the Apps Script code in a Google spreadsheet?
  6. Is there a way to evaluate a formula that is stored in a cell?
  7. Automatic timestamp when a cell is filled out
  8. Apps Script: how to get hyperlink from a cell where there is no formula
  9. How to auto select range from a filter without having to manually enter it?
  10. Sheet.getRange(1,1,1,12) what does the numbers in bracket specify?
  11. Google Apps Script, copy one spreadsheet to another spreadsheet with formatting
  12. Single Google Form for multiple Sheets [duplicate]
  13. How do I communicate a page(modal dialog) with its sibling (sidebar)?
  14. How to replace text in Google Spreadsheet using App Scripts?
  15. Google App Scripts cannot be given Authorization or Permission
  16. How to get the correct range to set the value to a cell?
  17. Google Apps Script: Dynamically creating spreadsheet menu items
  18. Increment Cell value by one by clicking
  19. email notification if cell is changed
  20. Dynamic selection options in Google Apps Script for forms
  21. Apply multiple font colors to the text in a single Google Sheets cell
  22. How to evaluate a spreadsheet formula within a custom function?
  23. Google Sheet use Importxml error could not fetch url [duplicate]
  24. On Edit doesnt work if cell auto updates – Need a workaround Google Sheets
  25. Determine current user in Apps Script
  26. Adding a property to an Html template gives error “Object does not allow properties to be added or changed”
  27. TypeError: Cannot read property ‘getRange’ of null (line 6, file “Code”) in google sheet script [duplicate]
  28. .setFormula() and received error missing ) argument list
  29. How can I merge multiple tabs in a Google Spreadsheet using Google App Script?
  30. Passing cell references to spreadsheet functions

Leave a Comment