Workbook.ApplyTheme method (Excel)

Applies the specified theme to the current workbook.

Syntax

expression.ApplyTheme (FileName)

expression A variable that represents a Workbook object.

Parameters

Name	Required/Optional	Data type	Description
FileName	Required	String	Full path and file name of a stored theme

Example:

Sub ApplyThemeExample()
    ActiveWorkbook.ApplyTheme "C:\Program Files\Microsoft Office\Root\Document Themes 16\Office Theme.thmx"
End Sub

Support and feedback

Have questions or feedback about Office VBA or this documentation? Please see Office VBA support and feedback for guidance about the ways you can receive support and provide feedback.