Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

Permanently change Excel 2003 Colors to company standards

Posted on 2011-02-10
4
Medium Priority
?
309 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 2000 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

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

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

Excel can be a tricky bit of software to get your head around. Whilst you’ll be able to eventually get to grips with the basic understanding of how to get by, there are a few Excel tips that not everybody will even know about let alone know how to d…
In Part II of this series, I will discuss how to identify all open instances of Excel and enumerate the workbooks, spreadsheets, and named ranges within each of those instances.
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…
Although Jacob Bernoulli (1654-1705) has been credited as the creator of "Binomial Distribution Table", Gottfried Leibniz (1646-1716) did his dissertation on the subject in 1666; Leibniz you may recall is the co-inventor of "Calculus" and beat Isaac…

926 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