Susan Harkins
harkins at iglou.com
Sat Apr 5 15:28:39 CST 2003
Using the simple loop to return menu commands. Now,
Private Sub Form_Load()
Dim cmdbar As CommandBar
For Each cmdbar In CommandBars
Debug.Print cmdbar.Name
Next
End Sub
Now, how do I tell which is the actual menu bar name -- such as Database,
Print Preview, etc. and which is a menu command (top level). I want to be
specific about the menu bar being named for changes, and right now, I'm not
even sure that's necessary -- if this will loop through all and find the
menu command I want, should be enough? Do I need to control the whole
process by matching a menu bar name first?
Susan H.