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. |
|
|
|
Thread Tools | Display Modes |
#11
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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 | |
|
|