Re : Excel to Insert an AutoFilter (at will)
Sub HideDropDown()
With ActiveSheet.UsedRange
.AutoFilter Field:=2, VisibleDropDown:=False
End With
End Sub
" wrote:
1. Enters an Excel WorkSheet.
2. Apply an AutoFilter in Column A. It's done. Easy.
3. Apply an AutoFilter in Column C. It can't be done until Column B is
also AutoFilter'd.
4. You see, Column B is reserved blank to serve as a divider between
Columns A and C.
5. Really don't wanna see an AutoFilter arrow in Column B. Again, it's
meant to be blank ; And, ...... it's not looking right to top a blank
column with a clickable Arrow'd button (where there ain't nothing else
to look for, anyway).
6. But still, how to have that (Column B's) button removed ?
7. Please share your experience. Regards.
|