In Google Sheets, How Do You Change The Sheet That The User Sees?
I have a Google Sheet spreadsheet with some javascript code in it. The user(s) begin on a default sheet and the code creates and names a sheet based on the user that is accessing i
Solution 1:
Try it with ss.setActiveSheet(ss.getSheetByName(username))
since the documentation states that 'Google Sheets UI displays the chosen sheet'.
Post a Comment for "In Google Sheets, How Do You Change The Sheet That The User Sees?"