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?
You should also change the color palette in the destination workbook to make it same as your source workbook.