Task Pane

  • Thread starter Thread starter WStoreyII
  • Start date Start date
W

WStoreyII

is it possible to manipulate the task pane through code in either
vba or vb.net

what i mean is if i make a add in can i add my own content to the task pane?

WStoreyII

Thanks Again
 
You can add your own files to the Task Pane, but nothing beyond that as far
as I know.

Sub AddToTaskPane()
Dim x As NewFile
CommandBars("Task Pane").Visible = False
Set x = Application.NewWorkbook
x.Add "c:\bookNew.xls", msoNew
CommandBars("Task Pane").Visible = True
End Sub

Sub RemoveFromTaskPane()
Dim x As NewFile
CommandBars("Task Pane").Visible = False
Set x = Application.NewWorkbook
x.Remove "c:\bookNew.xls", msoNew
CommandBars("Task Pane").Visible = True
End Sub


--
Jim Rech
Excel MVP
| is it possible to manipulate the task pane through code in either
| vba or vb.net
|
| what i mean is if i make a add in can i add my own content to the task
pane?
|
| WStoreyII
|
| Thanks Again
|
|
 
Back
Top