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
Solved

Permanently change Excel 2003 Colors to company standards

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

Three Reasons Why Backup is Strategic

Backup is strategic to your business because your data is strategic to your business. Without backup, your business will fail. This white paper explains why it is vital for you to design and immediately execute a backup strategy to protect 100 percent of your data.

Question has a verified solution.

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

Some code to ensure data integrity when using macros within Excel. Also included code that helps secure your data within an Excel workbook.
When you see single cell contains number and text, and you have to get any date out of it seems like cracking our heads.
This is Part 3 in a 3-part series on Experts Exchange to discuss error handling in VBA code written for Excel. Part 1 of this series discussed basic error handling code using VBA. http://www.experts-exchange.com/videos/1478/Excel-Error-Handlin…
Many functions in Excel can make decisions. The most simple of these is the IF function: it returns a value depending on whether a condition you describe is true or false. Once you get the hang of using the IF function, you will find it easier to us…

828 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