AllowFiltering Property

See Also         Example         Applies To

Protection object: True if worksheet filtering is enabled for the specified PivotTable list. This property has no effect if the Protection object’s Enabled property is set to False. Read/write Boolean.

PivotTable object: True if the user can modify filters. The default value is True. Read/write Boolean.

When this property is set to False, the following conditions are true:

• The AutoFilter command is disabled.
  
  
• The Filter By Selection command is disabled.
  
  
• The Move to Filter Area command is disabled.
  
  
• The Move to Detail command is disabled if the selection is a field in the filter area.
  
  
• All AutoFilter drop-down boxes are read-only. Note that the user can still view these boxes even though they are disabled.
  
  
• You can still set filters programmatically.
  
  
• Membership in the filter area is fixed; the user cannot drag a field to or from the filter area.