View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Jim May Jim May is offline
external usenet poster
 
Posts: 477
Default 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.