How to copy an Excel color scheme from one workbook to another

Question

Sometimes when I copy and paste from one workbook to another, the destination color scheme looks very odd. How can I copy the color scheme from one workbook to another

Answer 1

Open VBA and type the following (changing the names of the workbook as appropriate)

workbooks("DestinationWorkbook.xlsx").Colors=workbooks("SourceWorkbook.xlsx").Colors