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