DisplayWorkbookTabs Property [Excel 2003 VBA Language Reference]
True if the workbook tabs are displayed. Read/write Boolean.
Example
This example turns on the workbook tabs.
ActiveWindow.DisplayWorkbookTabs = True
Applies to | Window Object
See Also | TabRatio Property