Add missing built-in commands to the QAT or Ribbon
Ron de Bruin (last update 13-June-2010)
Go back to the Excel tips page
Many Excel 2007-2010 commands do not appear anywhere in the Ribbon, including some that used to be on the menus in Excel 2003. These commands still exist but you have to do something to make them available.

Examples of commands not in the Ribbon

Name in the "Commands Not in the Ribbon" list
Send to Mail Recipient
Camera
Add-ins
Select Visible Cells
Select Current Region
Form
Speak Cells by Columns
Speak Cells by Rows
Speak Cells on Enter
Speak Cells
Speak Cells - Stop Speaking Cells
Print Table


There are two ways you can make these commands and many others available.


Add missing commands to the Quick Access Toolbar (QAT)

You can add useful commands to your QAT like this:
Right click on the QAT and choose Customize Quick Access Toolbar.



In the “Choose commands from” dropdown choose "Commands Not in the Ribbon".
Then select the command you want in this long list and press “Add



Note: In the “Customize Quick Access Toolbar” dropdown choose “For <workbook name>
if you want to add the commands only to the ActiveWorkbook.



Add missing commands to your own custom Ribbon tab

Note: In Excel 2010 it is also possible to create a custom tab with missing controls in the UserInterface.

If you want to
add missing commands to your own custom Ribbon tab you
must know the RibbonX for the command that you want to add to the Ribbon tab.

The idMso of the command you can find like this, point to the command in the
"Commands Not in the Ribbon" list with your mouse and you see this.




Now we download a file in this section "Find the Control, Group and Tab names" on this page
http://www.rondebruin.nl/ribbon.htm

We search for the idMso of the command that you want to add to the Ribbon in this file.
You will find the Type of the command (button, toggleButton or ?) on the same row in this file.

Now we have enough information to create this line to add the command.
<toggleButton idMso="SendCopySendToMailRecipient" size="normal"/>



RibbonX example

The RibbonX below will create a new tab on the Ribbon with a few example commands.
You can save the workbook with the RibbonX below as a add-in if you want to use the
commands in all your workbooks.

Note: If you not know how to add RibbonX to your workbook check out this page
http://www.rondebruin.nl/ribbon.htm



<customUI xmlns="http://schemas.microsoft.com/office/2006/01/customui">
  <ribbon>
    <tabs>

      <tab id="CustomTab" label="Not in the Ribbon Tab" insertAfterMso="TabHome">

        <group id="YourCustomGroup1" label="Div Commands">
	  <toggleButton idMso="SendCopySendToMailRecipient" size="normal"/>
          <button idMso="Camera" size="normal"/>
	  <button idMso="AddInManager" size="normal"/>
          <button idMso="TableSelectVisibleCells" size="normal"/>
          <button idMso="SelectCurrentRegion" size="normal"/>
          <button idMso="DataFormExcel" size="normal"/>
        </group>

        <group id="YourCustomGroup2" label="Speak Commands">
          <toggleButton idMso="SpeakByColumns" size="normal"/>
          <toggleButton idMso="SpeakByRows" size="normal"/>
          <toggleButton idMso="SpeakOnEnter" size="normal"/>
          <button idMso="SpeakCells" size="large"/>
          <button idMso="SpeakStop" size="large"/>
        </group>
  
        <group id="YourCustomGroup3" label="Print">
          <button idMso="PrintListRange" size="large"/>			
        </group>

      </tab>

    </tabs>
  </ribbon>
</customUI>


More information

Add buttons to the QAT and customize the images of the buttons
http://www.rondebruin.nl/imageqat.htm


Change the Ribbon in Excel 2007 or Excel 2010
http://www.rondebruin.nl/ribbon.htm
There are more links in the "More Information" part of this page