Protection.AllowUsingPivotTables property (Excel)

Returns True if the user is allowed to manipulate PivotTables on a protected worksheet. Read-only Boolean.

Syntax

expression.AllowUsingPivotTables

expression A variable that represents a Protection object.

Remarks

The AllowUsingPivotTables property applies to non-OLAP source data.

The AllowUsingPivotTables property can be set by using the Protect method arguments.

Example

This example allows the user to access the PivotTable report and notifies the user. It assumes that a non-OLAP PivotTable report exists on the active worksheet.

Sub ProtectionOptions() 
 
 ActiveSheet.Unprotect 
 
 ' Allow PivotTables to be manipulated on a protected worksheet. 
 If ActiveSheet.Protection.Allow UsingPivotTables = False Then 
 ActiveSheet.Protect AllowUsingPivotTables:=True 
 End If 
 
 MsgBox "PivotTables can be manipulated on the protected worksheet." 
 
End Sub

Support and feedback

Have questions or feedback about Office VBA or this documentation? Please see Office VBA support and feedback for guidance about the ways you can receive support and provide feedback.