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