displayworkbooktabs = true problem

Question

I have a workbook that I disable the workbook tabls for using vba code.

When the workbook closes, I place the following code in the ThisWorkbook_Deactivate event:

With Application

        .DisplayFullScreen = False

        .CommandBars("Worksheet Menu Bar").Enabled = True

        .ActiveWindow.DisplayHeadings = True

        .ActiveWindow.DisplayGridlines = True

        .ActiveWindow.DisplayWorkbookTabs = True

 End With

When the workbook is closed and I create a new blank workbook, workbooktabs are not visible.

What other code do I need and in which events to make workbooktabs visible the next time I create a workbook?

Thanks

Answer 1

Are other statements are working ?

This settings are workbook level.Even if you do not run the statement the tab should be visible.