PERSONAL template

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

hmm - 14 Nov 2006 10:01 GMT

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.

Reply to this Message

Bob Phillips - 14 Nov 2006 10:14 GMT

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)

> I recently reinstalled Windows XP (including SP-2 update), and am
> reconfiguring Excel 2000. Some questions:
[quoted text clipped - 14 lines]
>
> Thanks.

Reply to this Message

Dave Peterson - 14 Nov 2006 14:25 GMT

Typo.

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

> The XLSTART directory has probably moved with the upgrade, so you need to
> move Personal.xls.
[quoted text clipped - 40 lines]
> >
> > Thanks.

Signature

Dave Peterson

Reply to this Message

hmm - 14 Nov 2006 15:10 GMT

Dave,

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

> Typo.
>
[quoted text clipped - 44 lines]
> > >
> > > Thanks.

Reply to this Message

Dave Peterson - 14 Nov 2006 16:13 GMT

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

> Dave,
>
[quoted text clipped - 52 lines]
> >
> > Dave Peterson

Signature

Dave Peterson

Reply to this Message