When you copy cells to a new workbook, they use colours from that
workbook's palette. You could copy the palette from the original
workbook to the new workbook:

Open the old workbook and the new workbook
In the new workbook, choose ToolsOptions
On the Color tab, in the 'Copy Colors from' dropdown, choose the old
workbook
Click OK

jkbond67 wrote:
Whenever I copy a sheet to a new workbook, the fill colors of the cells
change to a darker, or different color. I want them to remain the same as
when I copied them.


--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html