Thread: Task Pane
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Jim Rech Jim Rech is offline
external usenet poster
 
Posts: 2,718
Default Task Pane

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