changing an palette index value programmatically in Excel
Hi,
Vasant is correct. This is what I insert in one of my
modules, for example, in some of my workbooks. You record
with the macro to get the precise RGB (red-green-blue)
numbers that you want.
Sub Auto_Open()
With ActiveWorkbook
.Colors(2) = RGB(233, 230, 254)
.Colors(11) = RGB(232, 254, 243)
.Colors(15) = RGB(255, 204, 255)
.Colors(16) = RGB(251, 223, 255)
.Colors(19) = RGB(255, 255, 195)
.Colors(34) = RGB(195, 255, 255)
.Colors(35) = RGB(195, 255, 195)
.Colors(47) = RGB(227, 252, 255)
.Colors(48) = RGB(228, 225, 224)
.Colors(49) = RGB(252, 255, 227)
.Colors(55) = RGB(255, 248, 227)
.Colors(56) = RGB(227, 255, 245)
End With
End Sub
Rick
|