Taskpane does not show at startup

[Gaurab Hazarika]

Taskpane does not show up at startup. I did setup it up
to show during startup from the Tools-Options pulldown
menu.

Can anyone help. I am using Excel XP

[Kim Mitchell]

I have the same problem. I suspect that it is because my
macro workbook and Book1.xls load automatically. When any
workbook is opened, the Taskpane closes. At least, that's
how Word works. I'm thinking of creating (recording) a
VBA macro and putting it in "Workbook_Open" of my macro
workbook to see if that gets the Taskpane back. You might
try that too.

Kim

>.
>

[Dave Peterson]

There was a thread just a little while ago that discussed this:

Go to google and search for:

"Task Pane Execl XP" in the title

(excel is incorrectly spelled!)

You'll see a couple of answers from Robert Rosenberg and Jim Rech.

all on one line in your browser:

http://groups.google.com/groups?hl=en&threadm=eMz%24rW%24eBHA.1748%40tkmsftngp05&rnum=1&prev=/groups%3Fas_ugroup%3D*excel*%26as_usubject%3DTask%2520Pane%2520Execl%2520XP%26hl%3Den

--

Dave Peterson
ec3...@msn.com

[Kim Mitchell]

I tried Google but got no documents with either spelling.

Kim

>.
>

[Dave Peterson]

Did you click on the link? Or copy and paste into your browser.

I just looked at my previous message and clicked on that link and it went right
to the thread.

(It's kind of long, or I copy and paste!)

Oh heck, I copied and removed quoted text and combined....

There were two solutions: a macro based on and a registry change.

Here it is:

===============================
From: Shane Nation (Sh...@nation22.freeserve.co.uk)
Subject: Task Pane Execl XP
Newsgroups: microsoft.public.excel.misc
Date: 2001-11-30 10:59:05 PST

I am trying to get the task pane to be on when I open Execl XP. I have
shown it in the tool bars and ticked the show at startup box on the task
pane. When I open Excel it shows for a few seconds and then goes again.

Please has anyone got any ides.

Many thanks

Shane
==============================
From: Robert Rosenberg (bla...@email.msn.com)
Subject: Re: Task Pane Execl XP
Newsgroups: microsoft.public.excel.misc
Date: 2001-11-30 12:29:29 PST

I have created a work-a-round for this behavior. It's not a 1-2-3 process so
if you feel uncomfortable with all the steps below, just ignore it.

Before starting these steps, make sure the Task Pane is NOT visible.

1. Click Tools-->Macro-->Record New Macro...

2. Call it anything you like (no spaces allowed). For example, I'd call it
ShowTaskpane...

3. Make sure the "Store macro in:" option says Personal Macro Workbook (a
workbook that opnes and hides each time Excel starts)...

4. Click OK...

5. Click View-->Task Pane...

6. Click the blue Stop button on the Macro Recorder Toolbar (not the little
X, which just hides the toolbar)...

7. Now we need to make sure this macro automatically runs each time you
start Excel...

8. Click Tools-->Macro-->Visual Basic Editor...

9. Locate the file called Personal.xls on the left side of the Visual Basic
Editor window (VBE for short). The filename will be in parenthesis...

10. Double-Click Personal.xls to open up its components...

11. Locate and Double-Click the ThisWorkbook object...
A window will appear to the right with two drop down boxes at the top

12. Locate and click the drop down box in the upper left corner of the
Window that just opened up...
It should have the word General in it.

13. Click the Workbook choice on the drop down list...

14. A special Workbook_Open macro automatically appears. This macro will
automatically fire every time the Personal.xls opens. Remember that
Perosnal.xls automatically opens every time Excel does.

15. Finally, inside the Workbook_Open macro, type the name of the macro you
just recorded (ShowTaskPane)...

16. Exit the VBE and Excel and be sure and click YES when a prompt appears
asking you if you want to save changes to your Personal Macro Workbook.

Read the rest of this message... (22 more lines)

===follow up by Robert Rosenberg====

I forgot one thing...If you do have Excel 2000 and Excel XP on the same
system, they both share the same Personal.xls file. To prevent an error from
occuring when Excel 2000 opens (which doesn't have the task pane feature),
make sure the Workbook_Open procedure in your Personal.xls file looks like
this...

Private Sub Workbook_Open()
On Error Resume Next 'Suppress any macro errors
ShowTaskpane 'or whatever you called the recorded macro
End Sub

=============================
From: Jim Rech (jrr...@hotmail.com)
Subject: Re: Task Pane Execl XP
Newsgroups: microsoft.public.excel.misc
Date: 2001-11-30 12:49:36 PST

An alternative approach if you're willing to edit your registry with
Regedit.exe

Add the Dword item "DoNotDismissFileNewTaskPane" under
HKEY_CURRENT_USER\Software\Microsoft\Office\10.0\Common\General and assign
it the value 1.

--
Jim Rech
Excel MVP
================================
From: Jim Rech (jrr...@hotmail.com)
Subject: Re: Task Pane Execl XP
Newsgroups: microsoft.public.excel.misc
Date: 2001-12-03 04:27:50 PST

>>I still see this as a bug in XP

I was in the beta test and pointed out to them that if you have files
opening automatically when Excel starts (like Personal.xls) the Task Pane
appears and disappears. They opted not to fix it so I thought it was "by
design". Per this article it's a "problem" so maybe it will get fixed in
SR1 or whatever (or maybe not).

http://support.microsoft.com/default.aspx?scid=kb;EN-US;Q295341

This is better because it's Excel specific:

http://support.microsoft.com/default.aspx?scid=kb;EN-US;Q293820

--
Jim Rech
Excel MVP

--

Dave Peterson
ec3...@msn.com