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...
Tab Location remain visible
-
- 4StarLounger
- Posts: 545
- Joined: 30 Mar 2010, 18:49
- Location: United States
-
- Administrator
- Posts: 78631
- Joined: 16 Jan 2010, 00:14
- Status: Microsoft MVP
- Location: Wageningen, The Netherlands
Re: Tab Location remain visible
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.
See Freezing Worksheet Tabs for VBA code that you could use.
Best wishes,
Hans
Hans
-
- 4StarLounger
- Posts: 545
- Joined: 30 Mar 2010, 18:49
- Location: United States
Re: Tab Location remain visible
Thanks Hans. Some interesting Ideas there,!
-
- 4StarLounger
- Posts: 588
- Joined: 14 Nov 2012, 16:06
Re: Tab Location remain visible
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
-
- Administrator
- Posts: 78631
- Joined: 16 Jan 2010, 00:14
- Status: Microsoft MVP
- Location: Wageningen, The Netherlands
Re: Tab Location remain visible
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.
Best wishes,
Hans
Hans
-
- Administrator
- Posts: 78631
- Joined: 16 Jan 2010, 00:14
- Status: Microsoft MVP
- Location: Wageningen, The Netherlands
Re: Tab Location remain visible
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.
You do not have the required permissions to view the files attached to this post.
Best wishes,
Hans
Hans
-
- 4StarLounger
- Posts: 588
- Joined: 14 Nov 2012, 16:06
Re: Tab Location remain visible
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:
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