Add missing built-in commands to the QAT or Ribbon
Ron de Bruin (last update 18-Aug-2008)
Go back to the Excel tips page
Many Excel 2007 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 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.

More information about the QAT you can find on this page:

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



Add missing commands to your own custom Ribbon tab

If you want to know the RibbonX of Built-in commands that are in the Ribbon see this page.
http://www.rondebruin.nl/xmlribbongroups.htm

But 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.

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 on this page(point 3)
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"/>



Ribbon 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

Change the Ribbon in Excel 2007
http://www.rondebruin.nl/ribbon.htm

There are more links in the "More Information" part of that page