I need a way, using VBA, to determine when data filtering has been turned on or off and after that whether the number of hidden rows (due to filtering) has changed.

Using Excel 2007. Any help would be appreciated.