Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Re : Excel to Insert an AutoFilter (at will)
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. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Re : Excel to Insert an AutoFilter (at will)
Mr. Jim May,
Thank you for replying to my query. Will study. Regards. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
excel 2007 autofilter change to 2003 autofilter functionality? | Excel Discussion (Misc queries) | |||
2007 excel autofilter change back to 2003 autofilter? | Excel Discussion (Misc queries) | |||
Insert Row/Copy with Autofilter | Excel Discussion (Misc queries) | |||
Macro to insert formula using Autofilter | Excel Discussion (Misc queries) | |||
Copy and Insert Row problem when AutoFilter is ON | Excel Programming |