Microsoft Office Tutorials and References
In Depth Information
Prompting for a Directory
The ExecuteMso method accepts one argument, an idMso parameter that represents a Ribbon
control. Unfortunately, these parameters aren’t listed in the Help system.
The companion CD-ROM contains a file, ribbon control names.xlsx , that lists all
the Excel Ribbon command parameter names. You’ll need to experiment with the items
listed in this workbook. Many of them execute the command immediately (no dialog
box). And most will generate an error if they’re issued in an incorrect context. For
example, Excel displays an error if your code executes the FunctionWizard command
when a chart is selected.
Following is another example. This statement, when executed, displays the Font tab of the
Format Cells dialog box (see Figure 12-11):
Application.CommandBars.ExecuteMso(“FormatCellsFontDialog”)
Figure 12-11: Using the ExecuteMso method to display a dialog box.
 
Search JabSto ::




Custom Search