VBA Tip: Hide Tabs

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

Sub hideTabs()
    ActiveWindow.DisplayWorkbookTabs = False
End Sub

And to show tabs:

Sub showTabs()
    ActiveWindow.DisplayWorkbookTabs = True
End Sub