Workbook.Theme Property (2007 System)
Gets the theme that is applied to the workbook.
Namespace: Microsoft.Office.Tools.Excel
Assembly: Microsoft.Office.Tools.Excel.v9.0 (in Microsoft.Office.Tools.Excel.v9.0.dll)
Syntax
'Declaration
<BrowsableAttribute(False)> _
Public ReadOnly Property Theme As OfficeTheme
'Usage
Dim instance As Workbook
Dim value As OfficeTheme
value = instance.Theme
[BrowsableAttribute(false)]
public OfficeTheme Theme { get; }
[BrowsableAttribute(false)]
public:
property OfficeTheme^ Theme {
OfficeTheme^ get ();
}
public function get Theme () : OfficeTheme
Property Value
Type: OfficeTheme
A Microsoft.Office.Core.OfficeTheme that represents the theme that is applied to the workbook.
Examples
The following code example retrieves the theme of the current workbook. The example then displays the names of the major font and minor font found in the font scheme of the workbook theme.
This example is for a document-level customization.
Private Sub GetDocumentTheme()
Dim theme As Office.OfficeTheme = Me.Theme
Dim fontScheme As Office.ThemeFontScheme = theme.ThemeFontScheme
Dim majorFont As Office.ThemeFont = fontScheme.MajorFont.Item( _
Microsoft.Office.Core.MsoFontLanguageIndex.msoThemeLatin)
Dim minorFont As Office.ThemeFont = fontScheme.MinorFont.Item( _
Microsoft.Office.Core.MsoFontLanguageIndex.msoThemeLatin)
MessageBox.Show("Name of major font in current document theme: " _
+ majorFont.Name)
MessageBox.Show("Name of minor font in current document theme: " _
+ minorFont.Name)
End Sub
private void GetDocumentTheme()
{
Office.OfficeTheme theme = this.Theme;
Office.ThemeFontScheme fontScheme = theme.ThemeFontScheme;
Office.ThemeFont majorFont = fontScheme.MajorFont.Item(
Microsoft.Office.Core.MsoFontLanguageIndex.msoThemeLatin);
Office.ThemeFont minorFont = fontScheme.MinorFont.Item(
Microsoft.Office.Core.MsoFontLanguageIndex.msoThemeLatin);
MessageBox.Show("Name of major font in current document theme: "
+ majorFont.Name);
MessageBox.Show("Name of minor font in current document theme: "
+ minorFont.Name);
}
.NET Framework Security
- Full trust for the immediate caller. This member cannot be used by partially trusted code. For more information, see Using Libraries from Partially Trusted Code.