This is a workbook-level setting. Did you try recording a macro?

Something like:

ActiveWorkbook.Colors(3) = RGB(0, 128, 0)

should work.

--

Vasant




"brad" wrote in message
om...
Hi all,

I'm stuck, is there any way to change the color a palette index
references from VBA.

for example I want to change the color that colorindex(3) references
from blue to green, that way all my cells that reference colorindex(3)
change from blue to green.

can I do this in VBA?

thanks a lot
b