Tiger Chen
12-05-2006, 01:30 AM
In Excel, we can fill a shape with gradient colors. Two color's gradient filling including Forecolor and Backcolor. We can set either color into transparent manually.
However, with VBA, I can only set the forecolor into transparent. I cannot change the transparency of Backcolor - I even cannot record it when I do it manually.
When I look up transparency in Excel Help. It says transparency does not impact on gradient fill.
How can I set the backcolor into transparent by VBA code?
However, with VBA, I can only set the forecolor into transparent. I cannot change the transparency of Backcolor - I even cannot record it when I do it manually.
When I look up transparency in Excel Help. It says transparency does not impact on gradient fill.
How can I set the backcolor into transparent by VBA code?