What Sub is custom menu item running? [resolved]

[DaveBo]

I've added some custom menues in Word that invoke various VBA macro/subs.

But, when I go into the Tools - Customize screen I see no way to determine what sub is attached to any menu item.

The only way I can figure this out so far is to set a breakpoint in each sub in the VBA IDE, then clicking the menu item to see where it pauses.

Must be a better way. Thanks, DaveBo

[medison]

DaveBo,

Take a look at the OnAction property:

Sub ButtonList()
    Dim tb As CommandBar
    Dim c As CommandBarButton
    Dim s As String
    
    Set tb = CommandBars("MyToolBar")
    
    For Each c In tb.Controls
        s = s & c.Caption & " - " & c.OnAction
    Next c
    
    MsgBox s
    
    Set c = Nothing
    Set tb = Nothing
End Sub