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,
<*(((< ~~~
~~~~~~~~~~~