Open a new workbook. Customize the colors as you wish. FileSave
As Type: scroll down to Excel Template(*.XLT) and select. Name your workbook
"BOOK"(no quotes). Excel will add the .XLT to save as BOOK.XLT.

Store this workbook in the XLSTART folder usually located at........

C:\Documents and Settings\username\Application Data\Microsoft\Excel\XLSTART

This will be the default workbook for FileNew or the Toolbar button FileNew

Do not use FileNew...Blank Workbook or you will get the Excel default workbook.

Existing workbooks are not affected by these settings.

You can also open a new workbook and delete all but one sheet. Customize as
you wish.................... In your case, just copy the colors from BOOK.xlt
over to SHEET.xlt.......................then save this as SHEET.XLT in XLSTART
folder also. It now becomes the default InsertSheet.

More can be found on this in Help under "templates"(no quotes).


Gord Dibben MS Excel MVP

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

Gord Dibben MS Excel MVP