Problem setting transparency by VBA in XYScatter chart

Using Excel 2010 and VBA, I experience a problem when I try to set the transparency of the fill of circular data points of a seriescollection in an XYScatter chart. As soon as the relevant code line is executed, the fill colour changes to olive green regardless of the colour it has been originally. I tried the same basic code line in a line chart and it operated correctly. I also tried the code in a completely new chart and the problem persisted.

The relevant code line is

Please Login or Register  to view this content.

Any help?
Does anybody know whether the same problem occurs when using Excel 2013?

Thanks
itbcvdw

Thanks, Andy.
I tried your code with a new XYScatter chart, using only your code and nothing else, but the problem remains the same. The code functions correctly up to the instruction setting the ForeColor. When the next code line is executed, the ForeColor changes and the transparency does not change. It seems as if the ForeColor returns to the color that was used when the chart was created.

Does it function correctly in Excel 2013?

Cheers
itbcvdw

Thanks for your trouble, Andy, This works, but could become cumbersome because setting the transparency forms only part of a more complex process.

Is the problem of setting in VBA of transparency in XYScatter charts solved in Excel 2013? If so, I could upgrade.

Regards
itbcvdw

The problem remains with 2013. Perhaps 2014/15/?? will fix it.

Thank you very much both of you, Andy and Izandol.

So, I will have to work around the problem. This seems to be a very long-lasting Excel problem.

itbcvdw

Excellent, Andy! Thank you very much for your perseverance.

What is the rationale behind this? I added comments to your code according to what is happening:

Please Login or Register  to view this content.

Regards
itbcvdw

Andy, thank you very much for your help. Much appreciated!

Cheers
itbcvdw