You don't want to set your default save location to
your XLSTART directory.
Tools, Options, General
Default file location: ______________
it should be set to where you want your new Excel files
stored by default. You can override with File, Save As
when you first save a file.
---
HTH,
David McRitchie, Microsoft MVP - Excel
My Excel Pages:
http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page:
http://www.mvps.org/dmcritchie/excel/search.htm
"<*(((<" wrote in message ...
Thanks for your help. I saved BOOK as a template into the Startup
Folder. I edited my customized colors workbook to have just one sheet
and saved it as SHEET as a template into the Starup Folder.
Now, I have these in my startup folder:
C:\Documents and Settings\<myname\Application
Data\Microsoft\Excel\XLSTART
BOOK.xls
BOOK.xlt
SHEET.xls
SHEET.xlt
How did the *.xls files get in there? I promise I didn't do that!
I have these files next to the startup folder:
C:\Documents and Settings\<myname\Application Data\Microsoft\Excel\
XLSTART (a folder)
Excel.xlb
When I start Excell, it automatically opens with just one sheet, not
with a workbook. The sheet has my colors in it. But when I choose
Insert Worksheet, I get the default (not my colors).
When I close all the sheets and Choose File New, I get a workbook
with two sheets and my colors. But when I Insert Worksheet, it too
brings up the default sheet and not my customized colors.
Fortunately, now when I open a new Sheet or a new Workbook and save
it, it defaults to MY DOCUMENTS. This is an improvement!
Can you help me with the remaining issues? Thank you!
PS: The TEMPLATES folder is empty!
C:\Documents and Settings\<MyName\Application
Data\Microsoft\Templates
Awaiting your responses with baited breath, I remain, yours truly,
<*(((< ~~~
~~~~~~~~~~~
On Fri, 01 Sep 2006 20:43:03 -0700, "<*(((<" wrote:
I have reformatted the colors in Excel 2000. I've read the messages
about storing it in the Startup folder. But when I open a new
workbook, it tries to save over the one in the startup! That's not
what I want.
I want the template with the edited colors to be my default. I want
it to open as a new workbook, and I want it to save into my default
directory -- Data/Spreadsheets.
I also want, when I insert a new worksheet into the workbook, for the
worksheet with the edited colors to be inserted.
Can somebody help me?
~~~~~~~~~~~
Awaiting your responses with baited breath, I remain, yours truly,
<*(((< ~~~
~~~~~~~~~~~