Edit

Share via

Workbook.ApplyTheme method (Excel)

  • Article

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.