IsHyperlink Property

IsHyperlink property as it applies to the PivotField object.

Returns or sets whether the items in the specified field are to be treated as hyperlinks. Set this property to True in order to treat the items in the specified field as hyperlinks. The default value is False. Read/write Boolean.

expression.IsHyperlink

*expression   * Required. An expression that returns a PivotField object.

IsHyperlink property as it applies to the SchemaField and SchemaParameter objects.

Returns whether or not the specified field contains hyperlinks. Read-only Boolean.

expression.IsHyperlink

*expression   * Required. An expression that returns one of the above objects.

Example

As it applies to the PivotField object.

This example converts the items in the Merchant field in PivotTable1 to hyperlinks.

PivotTable1.ActiveView.FieldSets("Merchant") _
    .Fields(0).IsHyperlink = True

Applies to | PivotField Object | SchemaField Object | SchemaParameter Object

See Also | Hyperlink Property