1

I'm making a spreadsheet for users where I would like to have a specific range protected so they cannot be edited by users, but they can be edited by a macro that runs whenever the sheet is opened. I protected the range, but when users open the page it says they cannot edit the protected cells, as in the macro cannot edit the cells.

I know this is possible with VBA but I was wondering if there's something similar for Google Apps Script.

Thanks

Rubén
  • 34,714
  • 9
  • 70
  • 166
Thunderfluff
  • 21
  • 1
  • 1
    I have answered this on [this article](http://www.steegle.com/google-products/google-apps-script-faq#TOC-How-do-permissions-work-on-Apps-Script-) please take a look. – Henrique G. Abreu Jun 06 '14 at 18:42
  • Ive removed the -1 as its a valid question and docs are not clear. henrique's article has the solution (instalable triggers) – Zig Mandel Jun 10 '14 at 12:59

0 Answers0