Executing ribbon items

[RyderS]

Hi all,

This should be easy as pie, but for some reason it's a nightmare (to me, anyway)

Example: I asked how to use VBA to activate the Lasso Select... The answer was:

Call CommandBars("Drawing").Controls("Select Objects").Execute

Simple enough... but NOT SO FAST.

The Ribbon does NOT have a "Drawing" tab! It has a "Draw" tab. And if you call it "Draw" instead of "Drawing", the code fails.

What this seems to mean is this: The ribbon has "secret" names for everything... so you can't code any interaction with the ribbon unless you know all of the secret names. Now that is frustration set to 11. Why this would be the case is beyond my comprehension.

Does anyone have a secret decoder wheel where the VBA names are listed for all of the various ribbon items (under their "plain" names?)

Is there a good place to find a comprehensive "VBA interaction with the ribbon" article?

Everything I found was about changing the ribbon, or adding items which I specifically want to avoid like the plague.
Just manage the standard ribbon... all items, every tab.

Thank you so very much for your kind help.

R

[AlphaFrog]

This will list to the Immediate window the names of all your command bars.

Please Login or Register  to view this content.

This will list the controls for a given command bar. In this example, the "Borders" command bar.

Please Login or Register  to view this content.

I don't know of a good comprehensive reference for this topic.

[Andy Pope]

For the new ribbon controls you can use the name displayed in brackets within the tooltip when looking at all commands in the Customize Ribbon part of Options.

File > Options > Customize Ribbon

Office 2016 Help Files: Office Fluent User Interface Control Identifiers
https://www.microsoft.com/en-us/down....aspx?id=50745

[rorya]

The Commandbars predate the ribbon - they include the old menu/toolbar system - which is why they don't necessarily correspond to what you see on the Ribbon. As Andy mentioned, the updated version is to use the executemso method with the name of the ribbon control - for example:

Please Login or Register  to view this content.

for the lasso select tool.