Action Pane (Document Level)

Also known as the Document Actions task pane
You can create document action task panes for 2007 and later:
Using the VSTO ActionsPane object
available for Office 2003, Excel and Word from VSTO v2
available for Office 2007, Excel and Word from VSTO v2



ActionsPane.StackOrder
Microsoft.Office.Tools.StackStyle
Microsoft.VisualStudio.Tools.Applications.Runtime


Excel - Application.DisplayDocumentActionTaskPane
Word - Application.TaskPanes[wdTaskPanes.wdTaskPaneDocumentActions].Visible = True


ActionsPane.Hide - doesn't work
ActionsPane.Visible - doesn't work


The ActionsPane is actually a SmartDocument solution
ActionsPane.Clear - detach action pane from document
ActionsPane.Show - reattaches actionpane to document



The action pane is represented by the ActionsPane class
An instance of this class is available in both Excel and Word
In Excel - ThisWorkbook.ActionsPane (one per workbook)
In Word - ThisDocument.ActionsPane


Add windows forms controls to the Controls property of the ActionsPane fields


ActionsPane.Controls.Add (New MonthCalendar)
As soon as you add a control the task pane becomes visible immediately (by default).


Me.ActionsPane.Controls.Remove(mycontrol)

If Globals.ThisWorkbook.ActionsPane.Controls.Count < 1 Then 
   Application.CommandBars("Task Pane").Visible = False
End If

Display a built-in task pane

Application.TaskPanes(Word.wdTaskPanes.wdTaskPaneFormattng).Visible = True 

Me.CommandBars("Task Pane").Width = 150 

To detach the ActionsPane

Me.ActionsPane.Clear 



© 2024 Better Solutions Limited. All Rights Reserved. © 2024 Better Solutions Limited TopPrevNext