VBA Tip: Hide Tabs


To hide tabs in a workbook and thus prevent navigation between sheets, use the following code:

Sub hide_tabs()
    ActiveWindow.DisplayWorkbookTabs = False
End Sub

And to show tabs:

Sub show_tabs()
    ActiveWindow.DisplayWorkbookTabs = True
End Sub