IsHyperlink Property

This content is no longer actively maintained. It is provided as is, for anyone who may still be using these technologies, with no warranties or claims of accuracy with regard to the most recent product version or service release.  

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