Copy and paste to another Workbook changes color


#1

I have a sheet that has some cells with foreground color set to light gray (color was added to the palette in code). When the contents are copied and pasted to a new workbook the color of the cell changes to maroon. Is there any way to get this to come through to the new sheet?


#2

You should also change the color palette in the destination workbook to make it same as your source workbook.