Microsoft Office Tutorials and References
In Depth Information
20.7.4.2 LabelRange property
20.7.4.2 LabelRange property
The LabelRange property returns a Range object that represents the label cells for the PivotField.
To illustrate, the code:
ActiveSheet.PivotTables("Sales&Trans"). _
PivotFields("Store Type"). _
LabelRange.Select
will select just the cell containing the button labeled Store Type in Figure 20-26 .
20.7.5 Dragging Pivot Fields
The PivotField object has some properties that can prevent the user from moving the field. They
are as follows (all default values are True ):
DragToColumn property
Set to False to prevent the field from being dragged to the column area.
DragToHide property
Set to False to prevent the field from being hidden by being dragged off of the pivot
table.
DragToPage property
Set to False to prevent the field from being dragged to the page field area.
DragToRow property
Set to False to prevent the field from being dragged to the row field area.
20.7.6 Name, Value, and SourceName Properties
 
Search JabSto ::




Custom Search