Worksheet.EnablePivotTable Property (2007 System)
Gets or sets a value that indicates whether PivotTable controls and actions are enabled when user-interface-only protection is turned on.
Namespace: Microsoft.Office.Tools.Excel
Assembly: Microsoft.Office.Tools.Excel.v9.0 (in Microsoft.Office.Tools.Excel.v9.0.dll)
Syntax
'Declaration
<BrowsableAttribute(False)> _
Public Property EnablePivotTable As Boolean
'Usage
Dim instance As Worksheet
Dim value As Boolean
value = instance.EnablePivotTable
instance.EnablePivotTable = value
[BrowsableAttribute(false)]
public bool EnablePivotTable { get; set; }
[BrowsableAttribute(false)]
public:
property bool EnablePivotTable {
bool get ();
void set (bool value);
}
public function get EnablePivotTable () : boolean
public function set EnablePivotTable (value : boolean)
Property Value
Type: System.Boolean
true if PivotTable controls and actions are enabled when user-interface-only protection is turned on; otherwise, false.
Remarks
This property applies to each worksheet and is not saved with the worksheet or session.
There must be a sufficient number of unlocked cells below and to the right of the PivotTable report for Microsoft Office Excel to recalculate and display the PivotTable report.
.NET Framework Security
- Full trust for the immediate caller. This member cannot be used by partially trusted code. For more information, see Using Libraries from Partially Trusted Code.