I ve got an excel sheet which is converted from excel 2003 to 2007.
Unfortunately the background color of the legend is now transparant.
Can anyone tell me how to change this dynamically ?

i've tried:
legend.fill.backcolor.RGB = RGB(255,255,255)
but this doesn't work

thanks in advance.

Anique