Google Sheet script for keeping the first tab in view at all times?

0
votes

I have a Google Sheets spreadsheet with a lot of tabs that I frequently scroll though, but I wish that the master sheet I have (the first tab) is always displayed at the bottom no matter where I'm at in the scrolling process. That way I can just quickly click on the master sheet's tab to go back to it.

I know there's not a way to do this in any of the settings, but perhaps there's an onOpen trigger I could put in a script?

1
javascriptgoogle-apps-scriptgoogle-sheetsspreadsheet

1 Answers

1
votes

Nothing can control the tabs down below like that but I think you can script yourself to jump back to tab one from the menu

function onOpen() {
  var ui = SpreadsheetApp.getUi();
  ui.createMenu('Custom Menu')
      .addItem('Go To Tab 1', 'tab1')
      .addToUi();
}

function tab1(){
var sh = SpreadsheetApp.getActiveSpreadsheet();
var ss = sh.getSheetByName("Tab2");
sh.setActiveSheet(ss);
SpreadsheetApp.flush();

}

should do the trick