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
"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
|
|