Switch tab [active sheet] by script

Question

Is there a method to switch the tab (active sheet) from one to another by script?

As far as I can see, Activate() function on range or on sheet does not work this way.

Answer 1

If you are in say Sheet1 and want to move to Sheet2:

function myFunction() {
SpreadsheetApp.getActiveSpreadsheet().getSheetByName("Sheet2").activate();
}

The first time you try and run the above you have to grant authorisation.