This documentation is archived and is not being maintained.

SubtotalLabelForeColor Property

Office 2003

Returns or sets the foreground color for subtotal labels in the specified field. Read/write Variant.


expression    Required. An expression that returns a PivotField object.


When you set this property, you can use either a Long value representing a red-green-blue color value or a String value naming a valid HTML color value. For example, to set the object color to red, you could use the hexadecimal value &HFF, the decimal value 255, or the string value "red." In Microsoft Visual Basic, you can use the RGB function to create a red-green-blue color value (red is RGB(255,0,0)).

This property always returns the color as a Long value representing a red-green-blue color value.

Applies to | PivotField Object