Task Pane

[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

 

[Jim Rech]

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