Disable Spreadsheet copy - Google Sheets

Question

I would like to allow users to use my spreadsheet but not copy it as it contains intellectual property. I tried going to sharing settings and disabling:

1. Editors can change permissions and share

2. Viewers and commenters can see the option to download, print, and copy

But the sheet can still be copied. Ideas?

Answer 1

I think the simplest solution would be to copy and paste from the master file the range of values you want to share with the other document. In this scenario the editors of the other document won't have access to neither the code nor the full data of the master file since the latter won't be shared with them.

The copy and paste part can be done automatically via a script and a trigger mechanism to update the data automatically so you won't have to do anything manually and the master file won't be exposed to any user.