Exactly. They all use the same color chart. I edited the chart. Now
I want to make sure every book and sheet I open will use the chart I
edited.

How do I do that?

~~~~~~~~~~~
Awaiting your responses with baited breath, I remain, yours truly,
*((( ~~~
~~~~~~~~~~~

On Sat, 2 Sep 2006 05:17:23 -0400, "David McRitchie"
wrote:

Worksheets cannot have different colors, all worksheets
in a workbook have the same color chart.
---
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 ...
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,
*((( ~~~
~~~~~~~~~~~