Copy Theme from one Workbook to Another

The following sample code shows how to copy a theme from one workbook into another workbook. The code is useful for applying built‑in or custom themes. Simply create your desired theme (it could be a built‑in theme or a customized one) in your template file using Microsoft Excel, and then copy it to your source workbook using the following code.

Sample Code

Apply Custom Theme Colors of the Workbook using Array of Colors Create and Manipulate Excel Table