ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   How to increase the Width of the Task Pane (2003 & 2007)? (https://www.excelbanter.com/excel-programming/364715-how-increase-width-task-pane-2003-2007-a.html)

green

How to increase the Width of the Task Pane (2003 & 2007)?
 
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

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


All times are GMT +1. The time now is 03:42 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com