View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.setup
Bob Phillips Bob Phillips is offline
external usenet poster
 
Posts: 1,726
Default PERSONAL template

The XLSTART directory has probably moved with the upgrade, so you need to
move Personal.xls.

Do a Windows search to find Personal.xls.

Find the new directory by doing
?application.StartupPath
in the VBE immediate window, and move the file.

Toolbar info is stored in a .OLB file, which is probably located under the
old Excel version directory.

--

HTH

Bob Phillips

(replace xxxx in the email address with gmail if mailing direct)

"hmm" wrote in message
...
I recently reinstalled Windows XP (including SP-2 update), and am
reconfiguring Excel 2000. Some questions:

1. Before reinstalling XP, I had a template called PERSONAL that opened
automatically when I started Excel. I was able to view it by doing

Unhide.
Since reinstalling, the Unhide command is grayed out, meaning there is no
file to unhide. (Nor does the PERSONAL template appear in Macros as one

of
the files whose Macros to list.) What happened to the PERSONAL template

file?

2. I have (successfully) added buttons to the toolbars. As I understood,
configuration of toolbars is stored in the PERSONAL template. If there is

no
PERSONAL template, then where is the toolbar configuration being stored?

I would appreciate an explanation to the above points, to illuminate for

me
the way in which Excel stores and selects the default workbook template

and
toolbar configuration.

Thanks.