Page tree
    Created with Raphaël 2.1.0
    Loading...
Skip to end of metadata
Go to start of metadata

Introduced in build 8.6.1

Description

Sets or returns whether the worksheet will allow users to use AutoFilters when the worksheet is protected.

C#
public boolean AllowUseAutoFilter{ get; set; }
vb.net
Public Property AllowUseAutoFilter() As Boolean

Examples

C#
ExcelApplication xla = new ExcelApplication();
Workbook wb = xla.Open(@"C:\MySpreadsheet.xlsx");
Worksheet ws = wb.Worksheets[0];
ws.SheetProtection.AllowUseAutoFilter = true;
ws.Protect("password");
vb.net
Dim xla As New ExcelApplication()
Dim wb As Workbook = xla.Open("C:\MySpreadsheet.xlsx")
Dim ws As Worksheet = wb.Worksheets(0)
ws.SheetProtection.AllowUseAutoFilter = true
ws.Protect("password");
  • No labels