Window.DisplayWorkbookTabs Property (Excel)
True if the workbook tabs are displayed. Read/write Boolean.
Syntax
expression .DisplayWorkbookTabs
expression A variable that represents a Window object.
Example
This example turns on the workbook tabs.
ActiveWindow.DisplayWorkbookTabs = True