I have a single script that I want to assign to a button on multiple different spreadsheets. If I create a button on the spreadsheets and reference the script, which is stored in another parent folder on Google drive, I get the error Script function myScript could not be found. I can resolve this by going into each sheet with the button, selecting tools, selecting Script editor, and then pasting my script there. The problem with this is that myScript depends on multiple other scripts, so for a dozen sheets, I'd have to copy over multiple scripts as described above to "attach" them to the spreadsheet and make them accessible via button. This is an obvious challenge for updating scripts in the future.
Is there a way for me to make my one project with all the scripts globally available, so I don't have to copy/paste the same scripts to every spreadsheet?