You are here:   Home > Access - Ribbons > Ribbon XML / Controls > Commands

Commands

Commands allow you to manipulate the reaction of built-in Ribbon controls.

<customUI xmlns="http://schemas.microsoft.com/office/2006/01/customui">
   <commands>
       <command idMso="Help" enabled="true"/>
       <command idMso="WindowClose" enabled="true"/>
       <command idMso="WindowRestore" enabled="true"/>
       <command idMso="WindowMinimize" enabled="true"/>
       <command idMso="ApplicationOptionsDialog" enabled="true"/>
       <command idMso="FileExit" enabled="true"/>
       <command idMso="PrintDialogAccess" getEnabled="GetEnabled" onAction="CommandOnAction" />
   </commands>
   <ribbon startFromScratch="false">
   </ribbon>
</customUI>

 
The syntax for OnAction callback is a bit different to standard callbacks, as the Cancel parameter has to be provided. This Cancel parameter determines whether only your function or also the standard callback should be processed.

CancelDefault = False

Your code and the standard callback will be executed.

CancelDefault = True

Only your code will be executed.

 

Function in a standard module:

Sub CommandOnAction(control As IRibbonControl, ByRef CancelDefault)
  ' Callback for an Office Ribbon Control -  Click
  MsgBox "My Callback" 
  CancelDefault = True
End Sub

 

Callbacks: getPressed, getEnabled, onAction

You can find this sample also in Sample database Office-Option Button

 

 

Last Updates:

19.01.2013
Update Downloads for "Trusted Locations" - Versions for Office 2013 ...


29.08.2012
Revised versions for IDBE RibbonCreator2010 (Version 1.1014a) ...

07.08.2012
Update Group Attributes and Callbacks. ...

02.08.2012
New Access FAQ added. New Download added. ...

 

Last update:
April 07, 2013, 22:24