View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
STEVE BELL STEVE BELL is offline
external usenet poster
 
Posts: 692
Default Capture Auto-Filter Change

Thanks in advance for any help!

I am trying to capture an Auto-Filter change on a worksheet column.
The worksheet has several columns with Auto-Filter.
When the user changes the selection in any of these - I wish to capture the
event.
And if possible to identify whether or not they selected "All".

This is in Excel 2000.

(I am familiar with worksheet event code, but can't figure out how to
capture this one)

Again - Thanks...

--
steveB

Remove "AYN" from email to respond