Use VBA to change the xml previously created by Custom UI Editor to customize the ribbon

[evdokimos]

Hi all
I have created a new ribbon using the Custom UI Editor. Part of the xml is shown below. I want to change it by VBA so that if a boolean variable in my project is True then the 'enable property' (last line below) changes from 'false' to 'true'. Any ideas?

<tabs>
<tab id="MyCustomTab" label="MyTab" >
<group id="customGroup1" label="MyGroup">
<button id="customButton1" label="Caption 1" size="normal" onAction="MyMacro" imageMso="DirectRepliesTo" enabled="false" />
</group>
</tab>
</tabs>

 

[Jon Peltier]

It doesn't work this way. You need to put a callback in the XML, getEnabled, that calls a procedure in VBA. The VBA procedure returns a boolean, and this is what controls whether the ribbon element is enabled.

Your code didn't come through, so I can't really work on it.

But essentially you replace enabled="true" in the XML with getEnabled="IsItEnabled". The VBA callback is

Public Sub IsItEnabled(control As IRibbonControl, ByRef returnedVal)
  ' control.Id is the name of the control
  ' use control.Id and the state of the VBA project to decide whether to enable the control
  ' the value of returnedVal is the enabled property:
  returnedValue = True ' or False
End Sub