Excel macro screenupdating false
NOTE: Use the Field number, NOT the worksheet column number.
Sub Hide Arrows Specific Fields() 'hides arrows in specified fields Dim c As Range Dim i As Integer Dim rng As Range Set rng = Active Sheet.
Be sure that the filter is in place before you protect the sheet. You could use this type of code in other macros, to check a specific sheet for an Auto Filter.
NOTE: These macros do not turn the Auto Filter off. You can change the field number in the i Show variable, to leave a different field's arrow visible. Auto Filter Field:=i, _ Visibledropdown:=True Else c. Screen Updating = True End Sub The following Excel Auto Filter VBA procedure shows the arrows for all fields except field 2.
They just change the Visible Drop Down property to False, for some fields. NOTE: Use the Field number, NOT the worksheet column number. Rows(1) i = 1 i Show = 2 'leave this field's arrow visible Application. Auto Filter Field:=i, _ Visibledropdown:=False End If i = i 1 Next Application. Auto Filter Field:=i, _ Visibledropdown:=False Case Else c. You can change the field number in the i Hide variable, to hide a different field's arrow. Auto Filter Field:=i, _ Visibledropdown:=False Else c.
Show All Data End Sub You can use an Excel Auto Filter on a protected worksheet, but you can't create an Excel Auto Filter on a protected worksheet. If there is a worksheet Auto Filter on the active sheet, this code will print a line in the Immediate window, with a count of one.
Count - 1 & " Records" End Sub To see if a worksheet contains a worksheet Auto Filter, run this macro.