Apply theme to worksheet(s)
1. themeApply2w theme:="New Table";
2. themeApply2w theme:="New Table" option:=3;
3: themeApply2w theme:="New Table" option:=5 sheets:=[Book1]Sheet1;
Please refer to the page for additional option switches when accessing the x-function from script
Input
string
This variable specific the name of the theme that is used to apply to a worksheet.
int
Options
Option list
Specify the sheets that will be applied theme. This variable is used only if option:=5
This X-Function is used to apply the theme on a worksheet and some worksheets.
The following example shows how to use the X-Function themeApply2g:
1. New a workbook
2. Type themeApply2w -d in the command line window
themeApply2w -d
3. Select one of the values under theme combo box.
4. Select "Sheets in project" under option combo box.
5. Click OK to see the change.
themeEdit, themeApply2g