IsHyperlink Property

Microsoft Office Web Components Object Model

Show All

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