Search notes:

Excel: Page Layout -> Themes

Select the preferred visual theme or schemes.

These themes and schemes are stored in the following locations:

	Path	File extension
Theme	`C:\Program Files\Microsoft Office\root\Document Themes vv`	`.thmx`
Colors scheme	`C:\Program Files\Microsoft Office\root\Document Themes vv\Theme Colors`	`.xml`
Fonts scheme	`C:\Program Files\Microsoft Office\root\Document Themes vv\Theme Fonts`	`.xml`
Effect scheme	`C:\Program Files\Microsoft Office\root\Document Themes vv\Theme Effects`	`.eftx`

With VBA, these themes and schemes can be set with

ActiveWorkbook.ApplyTheme("C:\Program Files (x86)\Microsoft Office\root\Document Themes 16\Ion Boardroom.thmx")
ActiveWorkbook.Theme.ThemeColorScheme.Load("C:\Program Files (x86)\Microsoft Office\root\Document Themes 16\Theme Colors\Blue.xml")
ActiveWorkbook.Theme.ThemeFontScheme.Load("C:\Program Files (x86)\Microsoft Office\root\Document Themes 16\Theme Fonts\Arial.xml")
ActiveWorkbook.Theme.ThemeEffectScheme.Load("C:\Program Files (x86)\Microsoft Office\root\Document Themes 16\Theme Effects\Reflection.eftx")

Excel: Page Layout -> Themes

See also