Tab Location remain visible

[bradjedis]

Greeetings,

I am wondering if it is possible to have the Left most tab remain visible as the other tabs are scrolled thru. I have many tabs, but need to quickly access the Left Most tab, while keeping the tab I am working in visible in the tab list...

[HansV]

No, there is no built-in option to do that. It has been requested (several times) in Microsoft's Feedback Portal for Excel, but the Excel team has indicated that they will not work on it (at least for now).

See Freezing Worksheet Tabs for VBA code that you could use.

[bradjedis]

Thanks Hans. Some interesting Ideas there,!

[snb]

You can easily add a control to the Quick Access Toolbar, referring to the macro in ThisWorkbook's Macromodule (ThisWorkbook.M_snb):

Code: Select all

Sub M_snb()
   Application.Goto Sheets(1).Cells(1)
End Sub

[HansV]

Hi snb, that works to activate the first sheet, but it doesn't leave the tab of the previously active sheet visible if the workbook contains many sheets, so there is no easy way to go back.

[HansV]

The attached workbook has a custom Quick Access Toolbar button that lets you switch between the current sheet and the first sheet. The keyboard shortcut is Ctrl+Shift+S.

BackAndForth.xlsm

[snb]

No need to keep tabs visible.
You only have to click the Commandbarcontrol to switch between sheets(1) and the activesheet.
Macro in personal.xlsb:

Code: Select all

Sub M_snb()
  If ActiveWorkbook.ActiveSheet.Index = 1 Then
     ActiveWorkbook.Sheets(Val(Mid(ActiveWorkbook.Names("snb"), 2))).Activate
  Else
     ActiveWorkbook.Names.Add "snb", ActiveWorkbook.ActiveSheet.Index
     ActiveWorkbook.Sheets(1).Activate
   End If
End Sub