Handling Sort and Filter Events in Excel (Navneet Gupta)

re: Handling Sort and Filter Events in Excel (Navneet Gupta)

babak — Wed, 30 Mar 2011 08:35:30 GMT

Hi Navneet,

How could I implement the right mouse button on a Ribbonbutton. In Office 2007/2010 I trigger an action when I click the left mouse button on a Ribbon button. With the right mouse button I have a context/ Dropdown menu. How I use my own dropdown or popup menu on a specific Ribbon button when I click the right button on it?

Thanks

Babak

re: Handling Sort and Filter Events in Excel (Navneet Gupta)

Lee — Fri, 29 Oct 2010 01:07:22 GMT

Hi Navneet,

Thanks very much for the response. Yes, we have hooked the SortAscendingExcel and SortDescendingExcel commands. We've tried hooking the ribbon commands and also the Office 2003 command bars. None of those hooks seem to catch the sort operation when it's initiated from within the auto-filter dropdown.

Any other ideas?

thanks,

Lee

re: Handling Sort and Filter Events in Excel (Navneet Gupta)

VSTOTeam — Wed, 27 Oct 2010 18:34:26 GMT

Hi Lee,

Did you look at SortAscendingExcel and SortAscendingExcel commands as per the control id workbook www.microsoft.com/.../details.aspx , They should be invoked from Auto-Filter dropdown.

Thanks,

Navneet

re: Handling Sort and Filter Events in Excel (Navneet Gupta)

Lee — Wed, 27 Oct 2010 18:26:27 GMT

We've hooked these four commands and they work well when directly invoking the sort command (e.g. from the ribbon). However, they do not seem to fire when sorting data via the sort commands within an auto-filter dropdown. Is there a way to catch these sort actions?

re: Handling Sort and Filter Events in Excel (Navneet Gupta)

CHEN Kai — Wed, 11 Aug 2010 04:59:28 GMT

Hi, great tutorials. But how can I catch the event, e.g. filter event, so that the add-in would know the changes of the filter criteria the user have made?