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.
|