DisplayWorkbookTabs: How to mirror Sheet Tabs option?

[Glenn]

I would like to use the DisplayWorkbookTabs to access the "Sheet Tabs"
check box value found on a workbooks' "View" option tab.

I would have thought that the
Application.ActiveWindow.DisplayWorkbookTabs would reflect this.
However, if I have a workbook with "Sheet Tabs" option unchecked, I
nonetheless find that Application.ActiveWindow.DisplayWorkbookTabs =
True immediately after loading the workbook file.

What code would I use to determine if the "Sheet Tabs" option is
checked/uncheked?

Thanks.

 

[Leith Ross]

Hello Glenn,

Place your code in the Workbook_Open event.

Sincerely,
Leith Ross

 

[Glenn]

Thanks, Leith.

Although it seems that that would work, I don't think I have that
option available. I am using Excel Automation from within VB, using
late binding. Unless I'm doing something wrong, apparently, I don't
get any Excel events using late binding.

Besides that, why is it that my code works in the Workbook_Open event,
yet if I place it in VB immediately after opening the document, it
doesn't?

Thanks.