I do not want people with edit access to be able to make a copy of the spreadsheet. Is it possible to do that? I know how to prevent people with only viewing access to do that but how do I do the same to editors?
Google-sheets – Prevent editors from being able to make a copy of the spreadsheet
google sheets
Related Solutions
you can remove border by:
- CTRL + \ (which removes all formatting)
- LEFT ALT + SHIFT + 6 (which removes all borders)
note: 6 not num 6
I see this question is quite old but thought I'd answer for of other searchers in the future.
You can't restrict editors from viewing the script editor.
You can, as you have started to explore, have a standalone script file which connects to the standalone spreadsheet.
In Drive click NEW > MORE > Google Apps Script
You connect the spreadsheet & the script together by using:
var ss = SpreadsheetApp.OpenFileById("[spreadsheetIdHere]")
Once the variable ss is assigned to the spreadsheet you can reference it in the standalone script the same as you would have done if it had been a bound script in the script editor.
The spreadsheet ID is the long number (marked as xxxx here) between 2 slashes for instance:
https://docs.google.com/spreadsheets/d/xxxxxxxxxxxxxxxxxxxx/edit#gid=0
I hope that gives you something to go on.
Related Topic
- Google-sheets – Copy Sheet To New Spreadsheet
- Google-sheets – Allow others to make google spreadsheet copies that retain the view/edit permissions of its parent spreadsheet
- Google-sheets – How to prevent anonymous users from creating new rows
- Google-sheets – How to keep hidden sheets hidden after someone makes a copy
- Google-sheets – A private copy of a Google Sheet for each person allowed to access the master spreadsheet
Best Answer
The only option for editors is to block them from changing permissions. You cannot stop them from making a copy.
You can learn more about owner options here.
You may also want to take a look at some of the workarounds here.