gordon613
Reputation: 2952
How to copy an Excel color scheme from one workbook to another
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
Upvotes: 4
Views: 4564
Answers (1)
gordon613
Reputation: 2952
Open VBA and type the following (changing the names of the workbook as appropriate)
workbooks("DestinationWorkbook.xlsx").Colors=workbooks("SourceWorkbook.xlsx").Colors
Upvotes: 5
Related Questions
- Preserve colors from vba when copy sheets to new workbook
- Copy colored cells in another spreadsheet to current spreadsheet
- How To Save Current Color Scheme in a variable and set a new workbook's color scheme to that variable
- Copy Excel theme color in a new workbook
- Copy values and colors from one workbook to another without copying conditional formatting
- Pulling Color Scheme from Cell and Applying to Macro
- How to copy all cell colors from one workbook to another in Excel VBA?
- Copying specific coloured cells onto a different worksheet
- Changing formatting of a cell in a different worksheet
- Move to new workbook as values by tab color?