Export (0) Print
Expand All

AllowFiltering Property

Office 2003

Determines whether AutoFilter can be enabled or disabled when the worksheet has been protected. This property has no effect if the Protection object's Enabled property is set to False. Setting this property to True disables the command on the toolbar. Users can still filter data if AutoFilter is enabled before this property is set to False. Read/write Boolean.

expression.AllowFiltering

expression    Required. An expression that returns a Protection object.

Determines whether a field an be added to or removed from the filter area of a PivotTable list, and whether the AutoFilter command on the toolbar is enabled. The default value is True. Read/write Boolean.

expression.AllowFiltering

expression    Required. An expression that returns a PivotTable object.

Example

This example locks all cells on Sheet1, enables the insertion and deletion of columns, disables the AutoFilter command on the toolbar, and then protects Sheet1.

Sub Protect_Worksheet()
Dim ptProtSheet1

'Lock all cells on the worksheet.
Spreadsheet1.Worksheets("Sheet1").Cells.Locked = True

Set ptProtSheet1 = Spreadsheet1.Worksheets("Sheet1").Protection

' Allows user to delete columns while Sheet1 is protected.
ptProtSheet1.AllowDeletingColumns = True

' Allows user to insert columns while Sheet1 is protected.
ptProtSheet1.AllowInsertingColumns = True

' Disable the AutoFilter command on the toolbar.
ptProtSheet1.AllowFiltering = False

' Protect Sheet1.
ptProtSheet1.Enabled = True
End Sub

This example disables filtering for the PivotTable list.

PivotTable1.AllowFiltering = False
				




Show:
© 2015 Microsoft