excel - Chart colors change when copying worksheet to a new workbook -

I have an Excel 2010 workbook that has a wide variety of charts used in our reporting, in a new workbook VBA code is written to copy selected worksheets:

  XLMaster.Sheets (x). After that copy: = XLClinic.Sheets (XLClinic.Sheets.Count)  

However, when I do this, the color changes in the chart.

If I open the worksheet 'manually' with the XLMaster, clicking on the worksheet name and

It will be very easy to re-apply the colors to a chart before it is copied, and you will be able to travel through the RGB algorithm is not needed. Select a chart and run it:

  ActiveChart.SeriesCollection srs.Format.Fill.Forecolor.RGB = srs.Format.Fill.Forecolor for each SRS in the form of all the Reckler ChargeFilm CRS .RGB next final sub  

It keeps the same color, but unknowingly unaware of it, which is completely confused color theme system launched in Office 2007. The above work on the top, column, and area chart, which is the format. Line and scatter chart lines and markers also use background and foreground colors.