I now understand the strategy behind not enabling the script gallery in the new Google spreadsheets.