Freeze Tabs

[SantasLittleHelper]

I have a workbook with 20 different tabs. Is it possible to have the 'Home' tab always visible? For example, when I scroll across to find sheet 15, I am still able to see the Home Tab.

The best way to describe it is to do the same as Freezing the First column in a sheet. The Home tab will be the first column and when scrolling across, the other columns (or tabs in this case) are hidden behind the Home tab.

 

[mabalo76]

https://www.extendoffice.com/documents/excel/2695-excel-lock-freeze-worksheet-tab.html

Look at this website

 

[SantasLittleHelper]

https://www.extendoffice.com/documents/excel/2695-excel-lock-freeze-worksheet-tab.html

Look at this website

I've tried this code but it doesn't seem to work... even when I change the Sheet Name in the script or when I change my tab name to 'Main-sheet'.

 

[Fluff]

There's no way of doing what you are after I'm afraid.
What mabalo76 pointed you to is the closest option, but will not work when scrolling through the sheets.

 

[Rick Rothstein]

I have a workbook with 20 different tabs. Is it possible to have the 'Home' tab always visible? For example, when I scroll across to find sheet 15, I am still able to see the Home Tab.

I am guessing you want this feature so that you have easy access back to the first worksheet. As Fluff pointed out, you cannot freeze a tab; however, you can get back to the first sheet somewhat easily by right clicking the "VCR icons" to the left of the tabs and clicking on the top displayed sheet name in the popup menu that appears.

 

[SpillerBD]

You could use the View/New Window and have one Window your "Home" worksheet and then use the other Window when you want to examine any other worksheet...
Alt/Tab

 

[SantasLittleHelper]

There's no way of doing what you are after I'm afraid.
What mabalo76 pointed you to is the closest option, but will not work when scrolling through the sheets.

Thanks for letting me know... I'll stop searching now

 

[My Aswer Is This]

Is you wanted a easy way to always get back to your Home Tab.

Run this script in a empty workbook with several sheets.
Run the script in the Home Tab
And you will see what it does.
The script will put a Hyperlink in column A of your Home Tab
The links when clicked on will take you to your sheets.
And if you click on Range("A1") of any sheet you will be taken back to your Home Tab.

Sub Link_To_Sheets()
'Modified 6/11/18 4:10 PM EDT
Dim i As Long
Dim ans As String
ans = ActiveSheet.Name
    For i = 2 To Sheets.Count
        Sheets(ans).Hyperlinks.Add Anchor:=Cells(i, 1), Address:="", SubAddress:="'" & Sheets(i).Name & "'" & "!" & Cells(1, 1).Address, TextToDisplay:=Sheets(i).Name
        Sheets(i).Hyperlinks.Add Anchor:=Sheets(i).Cells(1, 1), Address:="", SubAddress:="'" & Sheets(1).Name & "'" & "!" & Sheets(1).Cells(1, 1).Address, TextToDisplay:="Goto  " & Sheets(1).Name
    Next
End Sub