Google Scripts in Spreadsheet

0
votes

Is there a way to have a spreadsheet in Google Drive where the script is protected from modification / editing? Does anyone know if that is an option in the Script editor?

Another thing I'd like to ask. How does one do source control for the codes in their Google scripts?

Thanks.

3
google-apps-scriptgoogle-sheets

3 Answers

1
votes

WRT privacy / protection of scripts: Refer to the comments and answers on this question: How to protect the Apps Script code in a Google spreadsheet?.

Source Control? See Backing up Gapps source. The version tracking in the script editor is rudimentary, so you should consider doing source control outside - you'll have to get used to copy & paste.

1
votes

No you can't do it.

The script runs with the document permissions.

If you have Edit permissions on the document, you have edit permission on the script too.