Whenever I refresh a spreadsheet (after having changed some of its Apps Scripts code) with CMD
- R
, Safari closes the script editor tab automatically.
How can I avoid that this tab is being closed?
flush() Applies all pending Spreadsheet changes. Spreadsheet operations are sometimes bundled together to improve performance, such as when doing multiple calls to Range.
Make an edit in the script, but don't save. Refresh the spreadsheet. The tab with the script will ask you if you want to close the tab, so say no. It won't close on you anymore after that.
Also, you can use Tools > Script Manager from the spreadsheet to run functions, or even run them directly from the script editor if you don't want to refresh.
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With