This topic has not yet been rated - Rate this topic

PivotTable.PrintTitles Property

Office 2003

Office 2010

True if the print titles for the worksheet are set based on the PivotTable report. False if the print titles for the worksheet are used. The default value is False. Read/write Boolean.

Namespace: Microsoft.Office.Interop.Excel
Assembly: Microsoft.Office.Interop.Excel (in microsoft.office.interop.excel.dll)

Usage

'Usage
Dim pivotTable1 As PivotTable

Dim returnValue As Boolean
returnValue = pivotTable1.PrintTitles

Dim sampleValue As Boolean
pivotTable1.PrintTitles = sampleValue

Syntax

C++

bool PrintTitles {get; set;}

public boolean get_PrintTitles();
public void set_PrintTitles(boolean);

JScript

function get PrintTitles() : Boolean;
function set PrintTitles(Boolean);

Remarks

The row print titles are set to the rows that contain the PivotTable report’s column field items. The column print titles are set to the columns that contain the row items.

The PivotTable report must be the only one in the print area. To set an indented format for a PivotTable report, use the Format method.

Thread Safety

Any public static (Shared in Visual Basic) members of this type are thread safe. Any instance members are not guaranteed to be thread safe.

Platforms

Development Platforms

Windows XP Home Edition, Windows XP Professional, Windows Server 2003, and Windows 2000

Target Platforms

Reference

PivotTable Interface
Microsoft.Office.Interop.Excel Namespace

Other Resources

PivotTable Members

Did you find this helpful? Yes No

Not accurate

Not enough depth

Need more code examples

(1500 characters remaining)

Community Additions

ADD