I have a Google spreadsheet that I need some people to edit certain parts, so they need edit permission. I have locks on virtually everything else (except things like adding a sheet, but that won't break anything). The problem is that I use quite a few scripts, and I don't know how to block these users from editing them. Is there any way to protect these scripts from being edited from everyone except me?
Google-sheets – Protect Scripts in Google Spreadsheets
google sheetsgoogle-apps-script
Related Solutions
Though it's understandable why the spreadsheet owner could not be blocked out, it would seem reasonable to block the current user. But since a user cannot block themselves out using the GUI, the script cannot either.
However, if you're only worried about accidental edits, you can use:
protection.setWarningOnly(true);
This applies to all users, including the owner. Unfortunately, there is no way to set the warning text to something more helpful and the user can choose to ignore it.
The importrange suggestion is also a good one.
Short answer
Google Apps Script can't modify how the Google Drive UI behaves, but it already has features to open file on preview mode.
Alternatives
To open a file of the Google Docs editors type in preview mode,
- Alternative 1: Right click the file and select Preview
- Alternative 2: Select the file and click the preview button on the Google Drive toolbar
Related Topic
- How to Make Specific Cells Publicly Editable in Google Sheets
- Google-sheets – Find previous non-blank cell, but without a specified range in Google Sheets
- Google-sheets – Google Sheets forumla help
- Google-sheets – way to allow users to access Google Sheets with installable triggers without manually signing in
- Google Sheets – Apply Protection to Multiple Sheets
- Google Sheets Error – ‘Exception: Service Spreadsheets Failed’ When Using insertCells
Best Answer
I wonder why this question hasn't got a decent answer yet after more than 4 years.
It's surprisingly simple :-) Just create a new script (standalone, or under another spreadsheet), and replace all the
SpreadsheetApp.getActiveSpreadsheet()calls bySpreadsheetApp.openById("spreadsheet-id")in which the spreadsheet-id is the last part of the document URL;https://docs.google.com/spreadsheets/d/{spreadsheet-id}Using this easy trick, you access the shared spreadsheet by your own script that is not accessible to the others.