Solved

Permanently change Excel 2003 Colors to company standards

Posted on 2011-02-10
4
305 Views
Last Modified: 2012-06-22
The company has created a "standard" color palette.  Now, on individual workbooks, if I have the workbook with the new palete open and the create or open another workbook, I can import this color palete and it is fine.  However, when I close the workbooks and open a new workbook, the color palate is not the new one - how can I get the new one to be the standard color pallete for all workbooks?
0
Comment
Question by:ssmith94015
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
4 Comments
 
LVL 22

Expert Comment

by:rspahitz
ID: 34867108
I think you will need to put this into a template then open the template any time you need the company colors (which I guess it always).

After you save the file as a template, you can copy a shortcut from the saved location to your desktop to launch this any time you need it.
0
 
LVL 33

Expert Comment

by:jppinto
ID: 34867131
Create a new workbook with your desired colour palette, and save it as a template file called Book.XLT in XLSTART

jppinto
0
 
LVL 33

Accepted Solution

by:
jppinto earned 500 total points
ID: 34867148
...XLSTART folder (C:\Documents and Settings\<username>\Application Data\Microsoft\Excel\XLSTART).
0
 

Author Closing Comment

by:ssmith94015
ID: 34867253
Thank you both.  However, I want this to be universally  applied with the XLSTARTUP and that is the route I am taking with the template.
0

Featured Post

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Deploying a Microsoft Access application in a Citrix environment is not difficult but takes a few steps. However, Citrix system people are often of little help, as they typically know next to nothing about Access. The script provided here will take …
Freeze panes is an option within all variants of Excel to enable parts of a sheet to remain stationary when the cursor is in another part of the sheet. This is a very useful feature which is overlooked or under used.
The viewer will learn how to create two correlated normally distributed random variables in Excel, use a normal distribution to simulate the return on different levels of investment in each of the two funds over a period of ten years, and, create a …
This Micro Tutorial demonstrates in Microsoft Excel how to consolidate your marketing data by creating an interactive charts using form controls. This creates cool drop-downs for viewers of your chart to choose from.

751 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question