
What macro is a menu item pointing to?I've got a bunch of custon menu entries on my menu bar but I don't know which macro they point to. How can I find out? Word is a powerful word processor that simplifies a lot of steps by using wizards and point-and-click type commands. Programmers and power-users can add even more powerful features to Word by writing special functions in Visual Basic for Applications (VBA) that performs functions that may be specialized to a particular need. When done in a company setting, these features may be added to Word's menu bar to make it easier for users to find these commands. While this is a great feature, it can cause a few problems if the original programmer is no longer available to maintain the code and he didn't leave any comments as to which menu items called which functions. This is where Word's point-and-click interface is deficient. However, you can use VBA to make up for that deficiency. The macro listed below will create a list in the currently active document that lists every menu bar and tool bar, Command Bars in Microsoft speak, available to Word. It will then list every item on those Command Bars and which macro, if any, the item points to.
Public Sub CommandBarNames() ' Written by Westley Annis ' http://www.AskWestley.com Dim cbBar As CommandBar, ctControl As CommandBarControl For Each cbBar In Application.CommandBars
Category is Microsoft Office
(Article #10)
Comments
Thank you for the answer. Since I have VBA that installs menu items, I should have thought of it. I just did believe they had a UI to allow adding, but not for changing. Thanks again, This site is incredible!
This site is incredible! It's amazing the questions you get asked and you always come up
with the answer. I've just got to help you stay cool by buying you a
Snoball!
I do have a comment, now that you mention it!
|
|