View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Rick[_19_] Rick[_19_] is offline
external usenet poster
 
Posts: 52
Default 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