Logroastur
New member
Good macro conducted a search for list of Excel functions and formulas, not if I could do something similar to list the names of the menu bar for example if we use
get a list with the names of the menu bar
greetings and thanks in advance for your attention
Code:
Sub NameCommandbars()
Dim cbr, ctl, xFil As Long
xFil = 2
For Each cbr In CommandBars
Range("B" & xFil) = cbr.Name
For Each ctl In cbr.Controls
Range("C" & xFil) = ctl.Caption
xFil = xFil + 1
Next ctl
Next cbr
End Sub
greetings and thanks in advance for your attention