Custom colors

[ColorMad]

I hope someone can help me out on this one please!

I mixed a few new colors using RGB that I want applied to
certain cells on a spreadsheet that will be shared among
many users.

The problem is, I noticed that setting RGB only changes
the color pallette and if the user resets or changes their
color pallette, then my colors are all reset on the
spreadsheet (and they look bad!).

Apparently its all linked by the color index? i.e. If the
user changes their color index, that change updates the
spreadsheet color.

Is there is foolproof (or at least better) way of applying
custom shading to certain cells in a spreadsheet that will
be more stable (i.e. less changeable)???

Your example code would be most helpful. Thanks in advance
to all who respond...

 

[Dave Peterson]

I couldn't protect a workbook so that I couldn't reset the colors.

The only way I could think of is to reapply your color choices every so often.

You could put some code in the workbook_open (or auto_open) that would change it
to the way you liked each time the workbook opened.

You could put some code in the Workbook_SheetSelectionChange so that each time
they changed the selection, it would reset the colors.

On the other hand, if this is my copy of the workbook, I might get mad that you
won't let me change colors the way I like. (If the file is shared with lots,
then I see your point.)

Any chance that you could just mark the file ReadOnly and not let them make
changes to that workbook?

And some interesting reading (you didn't ask, but...)
http://www.mvps.org/dmcritchie/excel/colors.htm