Scripts are available for all my google spreadsheets
Excel supports the concept of a PERSONAL.XLS file, which contains my personal scripts that I want to use in any spreadsheet / workbook that I open.
How can I do something like this in Google Docs i.e. have a bunch of scripts that, no matter which google spreadsheet is open, will trigger the onOpen event and thus add my extra menu?
You cannot do this on Google Spreadsheets. However, the best practice is
- Write a standalone script using the onOpen function and other functions.
- Publish this as a library
- Write a wrapper onOpen in each of the generated spreadsheets manually. :( This wrapper function will call the onOpen library.
However, if you create a copy of the spreadsheet that has a script associated with it, then the copy will also have the script in it.
1) You can open Script and from the Publish menu select Check as Add-on.
2) Now under "Configure New Test" you can select a document and then run the add-in for that document.
Unfortunately, you must do this for each document one at a time. I would really love if there was a way to show Script accessibility for all of my spreadsheets, or at least have an easy way to install a personal add-on on a per-sheet basis, much like you can install an add-on from the marketplace, sort of like a personal marketplace.