Invoking New Workbook in Excel Task Pane
 

There is a TaskPane in MS Excel 2003 which starts by default with
"Getting started" panel. This is annoying cos users used to have "New
Document" pane active as default in previous versions (Office XP).
I found out that when you go to File-New, TaskPane opens New Document
panel - this is what i need. So, my idea is to write macro which will
execute the same command that is executed while choosing File-New.
Thanks in advance for any help.

Maja

Invoking New Workbook in Excel Task Pane
 

Hi Maja,

You can turn this off - it does my head in aswell!

Click the Tools menu, Options, General, Show Startup Task Pane.

On this options window, you can also turn of other annoying nags, such
as Paste Option and Insert Options (on the tab) and Function Tooltips
on the General tab, and Error Checking on the Error Checking tab.

Good luck,


Roly


--
roly
------------------------------------------------------------------------
roly's Profile: http://www.excelforum.com/member.php...o&userid=24631
View this thread: http://www.excelforum.com/showthread...hreadid=401437

Invoking New Workbook in Excel Task Pane
 

To show the "New Document" work pane, you can use
CommandBars.FindControl(ID:=18).accDoDefaultAction

I tried CommandBars.FindControl(ID:=18).Execute first, but that doesn't
work for some reason.

accDoDefaultAction is a (hidden) accessibility method that usually does
the same as .Execute.

Id=18 is the Id of the built-in FileNew command.

Regards,
Klaus