Activating a sheet in Google Apps Script doesn't work

[Nate P]

I have created a Google Apps Script that is bound to a spreadsheet. I am trying to programmatically change the active sheet to Sheet2 when a user clicks on a particular cell in Sheet1.

From the documentation, this should be simple; there is a Sheet method called activate(). However, calling this function via a trigger does not change the active sheet - Sheet1 stays in focus. Other functions like hideSheet() and showSheet() work immediately, but not activate().

Any idea what I might be doing wrong? Am I using this function incorrectly?

Thank you in advance for your help!

-Nate

[Clark Lind]

This may help. Sometimes when I don't know the exact way to do a thing, I just record a simple Macro to see how Sheets handles it. 

function UntitledMacro() {

  var spreadsheet = SpreadsheetApp.getActive();

  spreadsheet.getRange('A1').activate();

  spreadsheet.setActiveSheet(spreadsheet.getSheetByName('Sheet2), true);

};

[Greg Noeninckx]

This worked for me. Thanks.