PivotTable.EnableDataValueEditing Property
Excel Developer Reference |
True to disable the alert for when the user overwrites values in the data area of the PivotTable. True also allows the user to change data values that previously could not be changed. The default value is False. Read/write Boolean.
Syntax
expression.EnableDataValueEditing
expression A variable that represents a PivotTable object.
Remarks
Any editing performed on data values is lost upon refresh.
Example
This example determines the alert setting for overwriting values in the data area and notifies the user. The example assumes a PivotTable exists on the active worksheet.
Visual Basic for Applications |
---|
|
See Also