Home |
Search |
Today's Posts |
#5
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Mr. Mitesh Khatri,
Thank you again for responding to the query. The query case refers to "ActiveSheet.AutoFilter.Filter(1)". Note that it is Filter(1) of the AutoFilter embedded on an ActiveSheet. Specificially, the Arrow-Button of Filter(1) has been subject to the effect of a Pertinent Argument Setting namely, VisibleDropDown = False ; and so, it has disappeared from the Lower Right-Hand-Side Corner of the Header-Cell atop the column of Filter(1). Meaning that it is One Arrow-Buitton of Filter(1) having disappeared ...... and there, it is so required to Test (and Track, via VBA Coding) the State of that Arrow-Button. You have suggested to test by, If Not myworksheet.AutoFilterMode Then myworksheet.Rows(RowNo).AutoFilter() ............ The statement wreaks an effect and there, so many Arrow-Button(s) would Emerge Enmasse ...... the result is apparently not at all relevant to the query case. You see?! the disappearance of an Arrow-Button (amidst several others thereof) as a result of VisibleDropDown = False does not suffice the Negation of AutoFilterMode. In practice, AutoFilterMode = False is the Negation of an (existing) AutoFilter implemented on an ActiveSheet. In the meantime, the pursuit to track the State of Arrow-Button of such AutoFilter.Filter(1) (being Toggled to Dis-Appear and Re-Appear) persists ; It's Not Over Until It Is Over. Regards. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
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) | |||
Re : Excel After-Life for an AutoFilter upon VisibleDropDown;=False | Excel Programming | |||
allow fill color to be changed or toggled using a formula | Excel Discussion (Misc queries) | |||
sometimes cannot see existing worksheet when i open it without full screen toggled on | Excel Discussion (Misc queries) |