Skip to content Skip to sidebar Skip to footer

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?"