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

Color schemes are set in the control panelAppearance and
ThemesDisplayAppearanceAdvanced

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


"Lucky" wrote in message
...
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

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

On Nov 29, 6:15�pm, "JLGWhiz" wrote:
Color schemes are set in the control panelAppearance and
ThemesDisplayAppearanceAdvanced

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

"Lucky" wrote in message

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


"Lucky" wrote in message
...
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

On Nov 29, 6:15?pm, "JLGWhiz" wrote:
Color schemes are set in the control panelAppearance and
ThemesDisplayAppearanceAdvanced

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

"Lucky" wrote in message

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



"Lucky" wrote in message
...
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

On Nov 29, 6:15?pm, "JLGWhiz" wrote:
Color schemes are set in the control panelAppearance and
ThemesDisplayAppearanceAdvanced

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

"Lucky" wrote in message

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.


"Peter T" <peter_t@discussions wrote in message
...
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



"Lucky" wrote in message
...
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

On Nov 29, 6:15?pm, "JLGWhiz" wrote:
Color schemes are set in the control panelAppearance and
ThemesDisplayAppearanceAdvanced

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

"Lucky" wrote in message

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- field
dropdown to grab the colour palette from another workbook.


--
p45cal

*p45cal*
------------------------------------------------------------------------
p45cal's Profile: http://www.thecodecage.com/forumz/member.php?userid=558
View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=157958

Microsoft Office Help