Thanks Bearacade, but it was the Task Bar and not the Task Pane I wanted. I
could still use this on a different project though.
I did however try changing the Task Pane to Bar, but it didnt want to know.
Regards
John
"Bearacade" wrote:
Hope this helps.. I have a task pane, is that the same?
Private Sub Workbook_Open()
Application.CommandBars("Task Pane").Visible = False
End Sub
Private Sub Workbook_Close()
Application.CommandBars("Task Pane").Visible = True
End Sub
--
Bearacade
------------------------------------------------------------------------
Bearacade's Profile: http://www.excelforum.com/member.php...o&userid=35016
View this thread: http://www.excelforum.com/showthread...hreadid=550033