Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Standard Colors
I changed one of the colors on the Tools / Options / Color Tab / Standard
Colors. I want to make it permanent but when I exited excel and then the next time I opened excel the color was changed back. How do I make it permanent? Thank you for your help. Steven |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Standard Colors
Steven
Color modifications are saved with the workbook that was open at the time. To have this modification for all NEW workbooks you can create a Template. Open a new workbook. Customize Views 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 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). To get the color mods into EXISTING workbooks you can also open a workbook with the mods and copy that scheme to your other workbook. ToolsOptionsColorCopy colors from. Gord Dibben Excel MVP On Fri, 20 Oct 2006 11:35:02 -0700, Steven wrote: I changed one of the colors on the Tools / Options / Color Tab / Standard Colors. I want to make it permanent but when I exited excel and then the next time I opened excel the color was changed back. How do I make it permanent? Thank you for your help. Steven Gord Dibben MS Excel MVP |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Standard Colors
And done. Thank you.
"Gord Dibben" wrote: Steven Color modifications are saved with the workbook that was open at the time. To have this modification for all NEW workbooks you can create a Template. Open a new workbook. Customize Views 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 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). To get the color mods into EXISTING workbooks you can also open a workbook with the mods and copy that scheme to your other workbook. ToolsOptionsColorCopy colors from. Gord Dibben Excel MVP On Fri, 20 Oct 2006 11:35:02 -0700, Steven wrote: I changed one of the colors on the Tools / Options / Color Tab / Standard Colors. I want to make it permanent but when I exited excel and then the next time I opened excel the color was changed back. How do I make it permanent? Thank you for your help. Steven Gord Dibben MS Excel MVP |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Standard Colors
I said that wrong.
That was beautiful!! As I looked closer at what you said there was so much in that response. Thank you very much. Steven |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Colors | Excel Discussion (Misc queries) | |||
Changing *permanently* Excel's colors and graph fill for charting? | Charts and Charting in Excel | |||
Using colors outside the standard palette | Excel Worksheet Functions | |||
custom cell pattern colors | Excel Worksheet Functions | |||
How to add fill colors (cell shading) in EXCEL? | Excel Discussion (Misc queries) |