Office applications have numerous Task Panes. I need to determine which are open/visible. Some are activated via ribbon toggle buttons and/or dialog box launchers while others are activated with buttons.
I can detect those activated with toggle buttons as in this example:
bSelectionPaneOpen = CommandBars.GetPressedMso("SelectionPane")
This doesn;t actually get the state of the task pane but the toggle button associated with it.
Conversely, I cannot do the same for those activated with a button. This example fails because the button isn't a toggle:
bFormatPaneOpen = CommandBars.GetPressedMso("ObjectFormatDialog")
Is there a way to return the visible state of task panes that are activated via buttons?
Word has a TaskPane object but Excel and PowerPoint don't :-(
lTaskPanes = Application.TaskPanes.Count