getEnabled

 

getEnabledThis Callback sets a boolean value to define whether a control is displayed as active or inactive.

 

 



Sample Ribbon XML file:

<customUI xmlns="http://schemas.microsoft.com/office/2006/01/customui" onLoad="CallbackOnLoad">
    <ribbon startFromScratch="false">
         <tabs>
             <tab id="Toogle Button Demo" label="Toogle Button Demo">
                <group id="MyGroup" label="Toogle Button Demo">
                    <button id="MyButton" label="I ;-)"
                      image="myImageEN.JPG" 
                      size="large" getEnabled="CallbackGetEnabled"/> 
                    <toggleButton id="MyToggleButton1" size="large" 
                      label="Toggle Button (On/Off)" imageMso="HappyFace"
                      onAction="MyToggleButtonCallbackOnAction"/>
                </group>
            </tab>
        </tabs>
    </ribbon>
</customUI>

Function to be copied to a standard module: 

Option Compare Database
Option Explicit
  
Public bolEnabled As Boolean
  
Sub CallbackGetEnabled(control As IRibbonControl, _
                       ByRef enabled)
' Callback Enabled
    enabled = bolEnabled
End Sub



Furthermore you require the Callback for clicking the ToggleButton

You can find this sample in Sample DB 2

 

Back