Thread: Filter
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Chuck[_9_] Chuck[_9_] is offline
external usenet poster
 
Posts: 5
Default Filter

As many in our org can't distinguish which columns are
filtered (is it a blue or black triangle?), is there a
manner in which that can (1) be made more prominent,
maybe red or blinking, or (2) through VBA, display the
text in the column in another cell -- I did try the
Worksheet_SelectionChange(ByVal Target As Range), but
clicking the filter "triangle" doesn't qualify as an
selection change.

Any feedback appreciated.

Thanks