Google Apps Scripts - Issue running script when sharing Spreadsheet with view only

Question

I created a spreadsheet app using the Script Editor. The users who I share it with are not that technical and I don't want them able to open the Script Editor and change anything, be it on accident or on purpose.

If they don't have access to edit the file then the script does not work (it basically launches a sidebar). I want the users to be able to edit anything in the file and to have access to the sidebar but I don't want them to have access to edit the script.

Is there anyway around this?

Answer 1

You can publish it as an add-on. Or use a library to protect your code from changes (but they'd still be able to change the script in the spreadsheet, that would have the some stubs and hooks to the library).