Often, one of the easiest things to do to check whether/how
something can be done programmatically, is to record a macro while
doing it manually. When I changed a color in the palette I got
something like:

ActiveWorkbook.Colors(56) = RGB(10, 229, 47)


In article ,
"John A Grandy" wrote:

is it possible to programmatically change the colors in the 56-color
palette?