How to monitor the built-in ribbon buttons

[Artik]

Hi Exceloholics.

I would like to monitor the clicks of some of the built-in ribbon buttons, e.g. all buttons responsible for sorting. So I would need something that will give me the ID of the clicked built-in button.
Is there a possibility?

Artik

[Andy Pope]

Use can use the Command option for specified idMso.
cancelDefault = False mean the builtin function will still be performed.

<customUI xmlns="http://schemas.microsoft.com/office/2006/01/customui" >
<commands >
<command
idMso="SortAscendingExcel"
onAction="SortAscend_onAction"/>
</commands >
</customUI >

module code

Sub SortAscend_onAction(control As IRibbonControl, ByRef cancelDefault)
    MsgBox "Sort Ascend"
    cancelDefault = False
End Sub

[Artik]

Thanks Andy. It's not bad. Monitors ribbon controls and pop-up menus.
But how to get to the sorting controls in the AutoFilter drop-down menu? I counted on finding IDs (idMso) for these controls, but I did not succeed.

Artik

[Andy Pope]

It does not appear to be a control you can access via ribbon xml.

[Artik]

It looks like we can not interfere with this list.
This thread dispels my hopes: https://social.msdn.microsoft.com/Fo...007?forum=vsto

Admittedly, my problem is not completely resolved, but I think it's time to end this topic.

Andy, thank you again.

Artik