When excel opens..

Wald1907 · External Since: Jun 24, 2004 Posts: 1

how do you get the window that shows your recent documents and other options (like 'new') to automatically be there when it opens. Mine flashes for a second then my Book1 opens and that's it.

I am using Windows Xp Professional with Excel 2002 I beleive.

Thanks so much!

Dave Peterson · External Since: Jul 21, 2004 Posts: 562

Are you Amy from Canada?

if yes, it's not necessary to multipost your question. If you're not, never
mind!

AFC (Amy from Canada) got this reply:

This link will give you a macro that you could put into your personal.xl*
workbook (so it runs whenever you open excel):

<a rel="nofollow" style='text-decoration: none;' href="http://support.microsoft.com/default.aspx?scid=kb;en-us;Q293820" target="_blank">http://support.microsoft.com/default.aspx?scid=kb;en-us;Q293820</a>

But Jim Rech has posted this registry tweak (only if you're comfortable with
messing with the windows registry):

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

Wald1907 wrote:
>
> how do you get the window that shows your recent documents and other options (like 'new') to automatically be there when it opens. Mine flashes for a second then my Book1 opens and that's it.
>
> I am using Windows Xp Professional with Excel 2002 I beleive.
>
> Thanks so much!

--

Dave Peterson
ec35720 DeleteThis @msn.com

Jazz · External Since: Nov 01, 2004 Posts: 7

While Excel is open, select View> task pain

at the bottom of this window, there is a "show at startup" checkbox. check it.

"Wald1907" wrote:

> how do you get the window that shows your recent documents and other options (like 'new') to automatically be there when it opens. Mine flashes for a second then my Book1 opens and that's it.
>
> I am using Windows Xp Professional with Excel 2002 I beleive.
>
> Thanks so much!

Ben · External Since: Jul 12, 2004 Posts: 222

With Excel 2002 open, click on 'Tools'
Then click 'Options'
Among the tabs along the top, click on the 'View' tab
Place a checkmark in the box for 'Startup Task Pane'

This should place the New Workbook box along the right-hand side of the
window. It could also show one of these following windows:
- Clipboard
- Search
- Insert Clip Art

If so, then click on the drop down arrow next to the name of the window and
change it to the one you prefer.

"Wald1907" wrote:

> how do you get the window that shows your recent documents and other options (like 'new') to automatically be there when it opens. Mine flashes for a second then my Book1 opens and that's it.
>
> I am using Windows Xp Professional with Excel 2002 I beleive.
>
> Thanks so much!