Lock a worksheet tab so it is always visible

[Bolter LAC]

Hello, I need to lock a worksheet tab (Main menu) in place so that it is always visible. There are multiple tabs that are all linked to the main menu by hyperlink. When work is finished in a worksheet I want the main menu tab to be visible and usable rather than using the scroll functions to get back to the main menu.

Thanks

 

[Sunny Kow]

Although the original question to lock the tab is 8 years old, it is pretty interesting.
I would suggest the following:

Add this into a module

Sub FreezeTab()
    'Move the worksheet before active sheet
    Worksheets("Locked Tab").Move before:=ActiveSheet '<=This is the tab that need to be "locked"
End Sub

Then for every sheet (except the "Locked" sheet) add this code for the worksheet event

Private Sub Worksheet_Activate()
    Dim CurrSheet As String
    Application.ScreenUpdating = False
    Application.EnableEvents = False
    CurrSheet = Selection.Parent.Name
    Call FreezeTab
    Sheets(CurrSheet).Activate
    Application.EnableEvents = True
    Application.ScreenUpdating = True
End Sub

Now when you select any worksheet (other than the locked sheet), the "locked" sheet will always appear on the left.
Hope this will help some one.

 

[curiousburke]

I know this is 8 more years old now, but Thank you. That solution is awesome!