VBA code to set transparency of data marker in xl2007

Here is code and an example workbook on how to set transparency of data marker in xl2007.
You can set the transparency by altering the colour property of
both Forecolor and Backcolor without resorting to changing chart type.