Excel VBA Bubble Chart bubble chart transparency

[lochlan]

I have created an bubble chart in excel 2007. I would like to make the bubbles 50% transparent using vba. I know how to do it manually and I have tried recording the macro while doing it. Strange enough, the macro is empty. Since it actually is possible to change the transparency of the bubbles, there should be a way to achieve the same result in vba. Does anyone know how? Thanks for your help in advance!

Bryan

ps. I have already tried:
Sub a()
Workbooks("book").Worksheets("sheet").ChartObjects("chart").Activate
ActiveChart.SeriesCollection(2).Format.Fill.Transparency = 0.5
End Sub
It runs, but nothing happens.

 

[Andy Pope]

Try

Sub a()
    with Workbooks("book").Worksheets("sheet").ChartObjects("chart").Chart
        with .SeriesCollection(2).Format.Fill
            .Solid
            .Transparency = 0.5
        end with
    End with
End Sub

 

[lochlan]

You are awesome Andy! Thank you very much!
Bryan