VBA Enable multiple Ribbon buttons

[decadence]

Hi, When invalidating the Ribbon control is there a way to enable multiple buttons from different groups on the ribbon?

I have followed Ron de Bruins example and have managed to make a group of buttons enable/disable based on column selection however I wish to add more buttons under this condition from another group of buttons on the same ribbon.

Code below uses the Tag for Group1 set of buttons but say if I wanted to Enable Group1, Group2 Button2, Group4 and Group5 button1 How can I invalidate the controls for these. Can someone help please

Sub MyEnableGroup1()
    Call RefreshRibbon(Tag:="Group1*")
End Sub

Sub RefreshRibbon(Tag As String)
    MyTag = Tag
    If iRib Is Nothing Then
        MsgBox "Error, Save/Restart your workbook"
    Else
        iRib.Invalidate
    End If
End Sub

 Sub GetEnabled(control As IRibbonControl, ByRef Enabled)
    If control.Tag Like MyTag Then
        Enabled = True
    Else
        Enabled = False
    End If
End Sub

 

[bobsan42]

in the XML ribbon structure each button myst have a getenabled callback assigned.
The same you did for groups, you must do for buttons as well.
All buttons that will have a change of state must have getenabled.

There is a trick though. I haven't tested it but I believe I am right: you cannot enable a button if it's parent group is disabled.
Does it make sense?