Solved

Permanently change Excel 2003 Colors to company standards

Posted on 2011-02-10
4
302 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
  • 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

Complete VMware vSphere® ESX(i) & Hyper-V Backup

Capture your entire system, including the host, with patented disk imaging integrated with VMware VADP / Microsoft VSS and RCT. RTOs is as low as 15 seconds with Acronis Active Restore™. You can enjoy unlimited P2V/V2V migrations from any source (even from a different hypervisor)

Question has a verified solution.

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

A little background as to how I came to I design this code: Around 5 years ago I designed an add-in that formatted Excel files to a corporate standard, applying different cell colours and font type depending on whether the cells contained inputs,…
Article by: Leon
Software Metering within our group of companies has always been an afterthought until auditing of software and licensing became a pain point. Orchestrator and SCCM metering gave us the answer and it was an exciting process.
The viewer will learn how to create a normally distributed random variable in Excel, use a normal distribution to simulate the return on an investment over a period of years, Create a Monte Carlo simulation using a normal random variable, and calcul…
This Micro Tutorial demonstrates how to create Excel charts: column, area, line, bar, and scatter charts. Formatting tips are provided as well.

773 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