Reset Color Scheme

[Lucky]

I use three computers. I've noticed that the colors I've set in
workbooks on one machine don't quite match the colors in the same
workbooks in another machine. Is this color scheme a property of the
workbook, or of the application? In any case, is there a way to reset
the colors to an Excel default within the workbook, so my files look
the same on all three PCs?

Thanks,
Lucky

 

[JLGWhiz]

Color schemes are set in the control panel>Appearance and
Themes>Display>Appearance>Advanced

When you change it there, it changes for all applications. But different
monitors might display the same colors with slightly different hues.

 

[p45cal]

look under -color palette- which is a workbook property.
On the -Tools -menu, click -Options-, and then click the -Color -tab
there's a -reset -button there, as well as -copy colours from- fiel
dropdown to grab the colour palette from another workbook

 

[Lucky]

Many thanks, JLG. Your comment is concise and will save me hours of
digging through big books. Do you know of a way in VBA to reset these
colors to a Windows "default"? Lacking that, is there a way I can get
a list of RGB settings for the Windows default color scheme?
Regards,
Lucky

 

[JLGWhiz]

on your desktop screen, just right click for the pop up menu. Click
properties and it will display the theme dialog box. Click the drop down
arrow and select Windows Classic for the default window color scheme.

For RGB equivalents, this site might help you.

http://www.mvps.org/dmcritchie/excel/colors.htm


Many thanks, JLG. Your comment is concise and will save me hours of
digging through big books. Do you know of a way in VBA to reset these
colors to a Windows "default"? Lacking that, is there a way I can get
a list of RGB settings for the Windows default color scheme?
Regards,
Lucky

 

[Peter T]

Lucky - strongly suggest you look at the reply given to you by p45cal before
changing system properties. In addition you can simply 'reset' the default
56 colour palette (manually or programmatically)

In Excel 2007, although the 56 colour palette still works (sort of),
workbooks now use "Themes", see PageLayout, Themes and/or Colors (on the
left of the ribbon)

Regards,
Peter T



Many thanks, JLG. Your comment is concise and will save me hours of
digging through big books. Do you know of a way in VBA to reset these
colors to a Windows "default"? Lacking that, is there a way I can get
a list of RGB settings for the Windows default color scheme?
Regards,
Lucky

 

[JLGWhiz]

I believe the reset on the palette is for the palette only. Not for the
window frames, tool bars and menu bars. I thought the OP was trying to set
a color theme for the Windows application colors, which is done through the
appearance facility of the display dialog box.