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
"WStoreyII" wrote in message
...
| 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
|
|