Sub MenuList()
On Error Resume Next
Dim Nx As CommandBar
Dim I As Integer
For Each Nx In Application.CommandBars
I = I + 1
Range("A" & I).Value = Nx.Name
Range("C" & I).Value = Nx.NameLocal
For Each X In Application.CommandBars(Nx.Name).Controls
I = I + 1
Range("B" & I).Value = X.ID
Range("C" & I).Value = X.Caption
Range("D" & I).Value = X.FaceId
Next
Next
End Sub
Sub MenuList()
On Error Resume Next
Dim Nx As CommandBar
Dim I As Integer
For Each Nx In Application.CommandBars
I = I + 1
Range("A" & I).Value = Nx.Name
Range("C" & I).Value = Nx.NameLocal
For Each X In Application.CommandBars(Nx.Name).Controls
I = I + 1
Range("B" & I).Value = X.ID
Range("C" & I).Value = X.Caption
Range("D" & I).Value = X.FaceId
Next
Next
End Sub