Using VBA with the Ribbon

Now, the big question: What can a VBA programmer do with the Ribbon? The simple answer is this: not much.

Following is a list of what you can do with the Ribbon using VBA:

• Determine whether a particular control is enabled.

• Determine whether a particular control is visible.

• Determine whether a particular control is pressed (for toggle buttons and check boxes).

• Get a control's label, screen tip, or supertip (a more detailed description of the control).

• Display the image associated with a control.

• Execute the command associated with a particular control.

Following is a list of things that you might like to do with the Ribbon but that aren't possible:

• Determine which tab is currently selected.