I have a work book with five excel sheets. I need to copy all five sheets to
new workbook .but when I copy to new workbook the color of the five excel
sheets change it does not maintain it's orginal color.I tried all ways even
copying cell by cell and range still color changes. If any body knows
solution do let me know

The source workbook has had some modifications done to its color palette.

These mods are saved with the workbook.

The new workbook won't have those mods so when you copy the sheets to new
book, the colors will be Excel default colors.

To keep the original colors, with both books open after the sheets have been
copied to new book..............................

In new book go to ToolsOptionsColor and "Copy colors from"

Select the source book and OK


Gord Dibben MS Excel MVP

On Tue, 22 Jul 2008 23:42:00 -0700, Sanjeev
wrote:

I have a work book with five excel sheets. I need to copy all five sheets to
new workbook .but when I copy to new workbook the color of the five excel
sheets change it does not maintain it's orginal color.I tried all ways even
copying cell by cell and range still color changes. If any body knows
solution do let me know