How this is done is very simple: Edit the XML This form gives access to all of the workbook’s options, including those reprsented by the checkboxes in the same grouping. What does it open? As you might guess from the Screentip, it is the main Options/Preferences form. There is a Dialog Box Launcher for the Preferences group. The previous image is from an estimating workbook which I coded. Generally with VBA programming you will have a form whose input is central to the group’s “theme”. The first thing you need is a dialog box which you want to open with the Launcher.

They are easy to setup on your own custom Ribbon… First Things First

However, I did find those dialog boxes and more.īehind those little diagonal arrows at the lower right of many of the command groups are what Microsoft calls Dialog Box Launchers. Where was the Font or Page Setup dialog boxes? After all these years of working with the Ribbon, I still have to ask the “Tell me what you want to do?” query box for help. Many items had been resorted into other categories or simply hidden.

If you were like me when the Ribbon menu first showed up in Office 2007 I was lost.

The dialog box launcher