BeforeSheetAdd

fires before a new sheet is added

boolean BeforeSheetAdd(){ ... };

Returns

booleantrue to add a sheet, false to prevent adding of a sheet

Example

spreadsheet.events.on("beforeSheetAdd", function() {
    console.log("A new sheet will be added");
    return true;
});

Details

The event is blockable, returning false will prevent adding of a sheet.

Change log

added in v4.1

Back to top