View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Chip Pearson Chip Pearson is offline
external usenet poster
 
Posts: 7,247
Default Capture Auto-Filter Change

There is no event capture this.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


"STEVE BELL" wrote in message
news:XD5Me.6765$rR4.4062@trnddc08...
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