Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
New Workbook Task Pane | Setting up and Configuration of Excel | |||
New Workbook Task Pane | Excel Discussion (Misc queries) | |||
Template Help Task Pane Appears When Workbook Is Open | Excel Discussion (Misc queries) | |||
Number of recently used templates on New Workbook task pane | Excel Discussion (Misc queries) | |||
Excel Task Pane | Excel Discussion (Misc queries) |