Window.DisplayWorkbookTabs (Excel)

True if the workbook tabs are displayed.

ActiveWindow.DisplayWorkbookTabs = True