A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Excel » Setting up and Configuration
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Colors as Default



 
 
Thread Tools Display Modes
  #11  
Old September 3rd, 2006, 11:31 PM posted to microsoft.public.excel.setup
external usenet poster
 
Posts: n/a
Default Colors as Default

Yabbut ,

When I open a workbook, I get the colors and gridlines and
everything I want.
When I insert a new worksheet, I get the default gridlines
instead.

I will try your suggestions.

Thank you!

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


On Sun, 03 Sep 2006 06:45:42 -0500, Dave Peterson
wrote:

Colors live in the workbook--not the worksheet. So adding a new worksheet to an
existing workbook won't change the color scheme of your workbook.



  #12  
Old September 3rd, 2006, 11:51 PM posted to microsoft.public.excel.setup
Dave Peterson
external usenet poster
 
Posts: 19,791
Default Colors as Default

Did you save the sheet.xlt file with gridlines off?

"*(((" wrote:

Yabbut ,

When I open a workbook, I get the colors and gridlines and
everything I want.
When I insert a new worksheet, I get the default gridlines
instead.

I will try your suggestions.

Thank you!

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

On Sun, 03 Sep 2006 06:45:42 -0500, Dave Peterson
wrote:

Colors live in the workbook--not the worksheet. So adding a new worksheet to an
existing workbook won't change the color scheme of your workbook.


--

Dave Peterson
  #13  
Old September 4th, 2006, 06:07 AM posted to microsoft.public.excel.setup
external usenet poster
 
Posts: n/a
Default Colors as Default

I customized the gridlines. They are light blue. And that's the way
they are in the customized BOOK.xlt & SHEET.xlt.

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

On Sun, 03 Sep 2006 17:51:41 -0500, Dave Peterson
wrote:

Did you save the sheet.xlt file with gridlines off?

"*(((" wrote:

Yabbut ,

When I open a workbook, I get the colors and gridlines and
everything I want.
When I insert a new worksheet, I get the default gridlines
instead.

I will try your suggestions.

Thank you!

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

On Sun, 03 Sep 2006 06:45:42 -0500, Dave Peterson
wrote:

Colors live in the workbook--not the worksheet. So adding a new worksheet to an
existing workbook won't change the color scheme of your workbook.


  #14  
Old September 4th, 2006, 02:46 PM posted to microsoft.public.excel.setup
Dave Peterson
external usenet poster
 
Posts: 19,791
Default Colors as Default

Sorry, I don't have another guess.

"*(((" wrote:

I customized the gridlines. They are light blue. And that's the way
they are in the customized BOOK.xlt & SHEET.xlt.

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

On Sun, 03 Sep 2006 17:51:41 -0500, Dave Peterson
wrote:

Did you save the sheet.xlt file with gridlines off?

"*(((" wrote:

Yabbut ,

When I open a workbook, I get the colors and gridlines and
everything I want.
When I insert a new worksheet, I get the default gridlines
instead.

I will try your suggestions.

Thank you!

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

On Sun, 03 Sep 2006 06:45:42 -0500, Dave Peterson
wrote:

Colors live in the workbook--not the worksheet. So adding a new worksheet to an
existing workbook won't change the color scheme of your workbook.


--

Dave Peterson
  #15  
Old September 7th, 2006, 02:47 PM posted to microsoft.public.excel.setup
David McRitchie
external usenet poster
 
Posts: 606
Default Colors as Default

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




 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 12:59 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.