2.14.13 themeApply2w

Brief Information

Apply theme to worksheet(s)

Command Line Usage

1. themeApply2w theme:="New Table";

2. themeApply2w theme:="New Table" option:=3;

3: themeApply2w theme:="New Table" option:=5 sheets:=[Book1]Sheet1;

X-Function Execution Options

Please refer to the page for additional option switches when accessing the x-function from script

Variables

Display
Name
Variable
Name
I/O
and
Type
Default
Value
Description
Theme theme

Input

string

<unassigned>

This variable specific the name of the theme that is used to apply to a worksheet.

Option option

Input

int

active

Options

Option list

  • active:Current Sheet
    Apply to current sheet
  • book:Sheet in Book
    Apply to all Sheets in the active Book
  • folder:Sheets in Folder
    Apply to all sheets in the active Folder
  • recursive:Sheets in Folder(Recursive)
    Apply to all sheets in the active Folder and its subfolder
  • project: Sheets in Project
    Apply to all sheets in the current project
  • specified:Specified
    Manually define which sheets to be applied.
Worksheets sheets

Input

string

<unassigned>

Specify the sheets that will be applied theme. This variable is used only if option:=5

Description

This X-Function is used to apply the theme on a worksheet and some worksheets.

Examples

The following example shows how to use the X-Function themeApply2g:

1. New a workbook

2. Type themeApply2w -d in the command line window

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.

Related X-Functions

themeEdit, themeApply2g