Thread: How to increase the Width of the Task Pane (2003 & 2007)?
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Andy Pope Andy Pope is offline
external usenet poster
  
Posts: 2,489
Default How to increase the Width of the Task Pane (2003 & 2007)?
Hi,

For xl2003 at least,

application.CommandBars("Task Pane").Width =400

In .Net I believe there is a ActionPane object you can control.

Cheers
Andy

Green wrote:
Hi, does anybody know how to can programmatically increase the width of the
task pane in Office 2003 & 2007.
(using .Net or unmanaged code etc)
I think the default width for the task pane is 200 pixels.

Thank you
eg



--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info
Reply With QuoteReply With Quote