Dear Sir,

I have a problem in keeping the color setting of a worksheet for other new
files.

At first, I go to Tool Option Color Modify , and click OK to set my
favorite color template.

After that, I save these setting in that file. However when I open up other
new files, those new setting does not retain. It always get back to the
default color setting.

Is there anyway to overcome this problem ?


Thanks

Low




--
A36B58K641

See he http://office.microsoft.com/en-us/ex...989351033.aspx

Dave
--
A hint to posters: Specific, detailed questions are more likely to be
answered than questions that provide no detail about your problem.


"Mr. Low" wrote:

Dear Sir,

I have a problem in keeping the color setting of a worksheet for other new
files.

At first, I go to Tool Option Color Modify , and click OK to set my
favorite color template.

After that, I save these setting in that file. However when I open up other
new files, those new setting does not retain. It always get back to the
default color setting.

Is there anyway to overcome this problem ?


Thanks

Low




--
A36B58K641

Create a default template with your desired color scheme (see "Create a
template for workbooks or worksheets" in XL Help).

In article ,
Mr. Low wrote:

Is there anyway to overcome this problem ?

Thanks

--
A36B58K641


"Dave F" wrote:

See he http://office.microsoft.com/en-us/ex...989351033.aspx

Dave
--
A hint to posters: Specific, detailed questions are more likely to be
answered than questions that provide no detail about your problem.


"Mr. Low" wrote:

Dear Sir,

I have a problem in keeping the color setting of a worksheet for other new
files.

At first, I go to Tool Option Color Modify , and click OK to set my
favorite color template.

After that, I save these setting in that file. However when I open up other
new files, those new setting does not retain. It always get back to the
default color setting.

Is there anyway to overcome this problem ?


Thanks

Low




--
A36B58K641

Thanks

Low
--
A36B58K641


"Dave F" wrote:

See he http://office.microsoft.com/en-us/ex...989351033.aspx

Dave
--
A hint to posters: Specific, detailed questions are more likely to be
answered than questions that provide no detail about your problem.


"Mr. Low" wrote:

Dear Sir,

I have a problem in keeping the color setting of a worksheet for other new
files.

At first, I go to Tool Option Color Modify , and click OK to set my
favorite color template.

After that, I save these setting in that file. However when I open up other
new files, those new setting does not retain. It always get back to the
default color setting.

Is there anyway to overcome this problem ?


Thanks

Low




--
A36B58K641

I have a spreadsheet that used a different color template - now everything is
defaulting to that color scheme.

I have tried to reset - to no avail.

Also tried to open a new sheet with the template I want to copy from, the
minute I open sheet I want to copy too - both sheets default to the color
scheme I don't want.

It seems I can only get back to create sheets in standard color mode - if I
don't open this one particular sheet.



--
LeSha


"Dave F" wrote:

See he http://office.microsoft.com/en-us/ex...989351033.aspx

Dave
--
A hint to posters: Specific, detailed questions are more likely to be
answered than questions that provide no detail about your problem.


"Mr. Low" wrote:

Dear Sir,

I have a problem in keeping the color setting of a worksheet for other new
files.

At first, I go to Tool Option Color Modify , and click OK to set my
favorite color template.

After that, I save these setting in that file. However when I open up other
new files, those new setting does not retain. It always get back to the
default color setting.

Is there anyway to overcome this problem ?


Thanks

Low




--
A36B58K641

Hello LeSha

I share the same experience as you.

I could only retain the color template for a particular file by saving it.

Other new files I open will have the color template back to its original
default setting.

For Excel 2002, the defauly color template is less suitable for shading as
it is too dark. LIght color shading only look good.


Low
--
A36B58K641


"LeSha" wrote:

I have a spreadsheet that used a different color template - now everything is
defaulting to that color scheme.

I have tried to reset - to no avail.

Also tried to open a new sheet with the template I want to copy from, the
minute I open sheet I want to copy too - both sheets default to the color
scheme I don't want.

It seems I can only get back to create sheets in standard color mode - if I
don't open this one particular sheet.



--
LeSha


"Dave F" wrote:

See he http://office.microsoft.com/en-us/ex...989351033.aspx

Dave
--
A hint to posters: Specific, detailed questions are more likely to be
answered than questions that provide no detail about your problem.


"Mr. Low" wrote:

Dear Sir,

I have a problem in keeping the color setting of a worksheet for other new
files.

At first, I go to Tool Option Color Modify , and click OK to set my
favorite color template.

After that, I save these setting in that file. However when I open up other
new files, those new setting does not retain. It always get back to the
default color setting.

Is there anyway to overcome this problem ?


Thanks

Low




--
A36B58K641