PERSONAL template

[hmm]

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.

 

[Bob Phillips]

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)

 

[Dave Peterson]

Typo.

Toolbar info is stored in a .XLB file (not .OLB).

 

[hmm]

Dave,

What is its filename, and in what folder should it be placed?

 

[Dave Peterson]

The filename varies with versions of excel. The location varies with versions
of windows and excel.

I like to make a minor change to one of the toolbars, then I look for *.xlb.

For me (xl2003 and winXP Home), it's in:
C:\Documents and Settings\(usernamehere)\Application Data\Microsoft\Excel
And is named:
excel11.xlb