Modified Color Option

[JAD]

I recently modified the standard color selection by adding a number of shades
of blue and applied them to the worksheet's. After completing the project, I
sent it to my boss who opened it with the standard collor group, Instead of
light blue, he was looking at deep purple. Is their a way that I can attach
the modified color group to the workbook? Any help would be appreciated.
Thank You, JAD

[Dave Peterson]

Color schemes live in the workbook. If you did this correctly, your boss should
see the same colors that you defined in that workbook. You may want to try
again to make sure you did want you wanted to do.

And all this is subject to how his pc displays colors. Maybe there are (slight)
differences between monitors/video cards. But I've never seen too much
difference.

JAD wrote:
>
> I recently modified the standard color selection by adding a number of shades
> of blue and applied them to the worksheet's. After completing the project, I
> sent it to my boss who opened it with the standard collor group, Instead of
> light blue, he was looking at deep purple. Is their a way that I can attach
> the modified color group to the workbook? Any help would be appreciated.
> Thank You, JAD

--

Dave Peterson

[FSt1]

hi,
It has been my experience that customizations applies only to the pc being
customized. it does not effect files or other pcs.
you can create custom colors on another pc with a macro.
ActiveWorkbook.colors(1) = RGB(1,1,1)
the single number is the color being modified and the 3 numbers after RGB is
the custom color. if you don't know the color numbers, the color editor at
Tools>options>color tab>modify button>custom tab will tell you. you can do
the whole thing on record and the recorder will tell you the custom color
number and the default color number being modified. you can put the macro in
the file open event.
remember...putting custom features on someones else's pc is considered by
some as impolite and some equate them to viruses so in the before close
event, remove any customization that you do.
ActiveWorkbook.ResetColors
I've never done this with colors but i have done it with toolbars. and i am
speaking of xp and before. versions of excel after xp may be different.
good luck
Regards
FSt1


"JAD" wrote:

> I recently modified the standard color selection by adding a number of shades
> of blue and applied them to the worksheet's. After completing the project, I
> sent it to my boss who opened it with the standard collor group, Instead of
> light blue, he was looking at deep purple. Is their a way that I can attach
> the modified color group to the workbook? Any help would be appreciated.
> Thank You, JAD