VBA Enable ribbon button on selection of a column

[decadence]

Hi I am trying to enable a ribbon button if a column is selected, I know I need to use the on selection change event but not sure how I do this, Can someone help please

 

[manc]

decadence,

I have no idea how to do it, but could you try recording a macro to achieve what you want and then jump into the code to see what it says? Worth a try i reckon.

Best regards
manc

 

[decadence]

Hi manc, Unfortunately recording a macro won't help with this. I have found some code though but just need help with enabling the ribbon button, see code below

    Private Sub Worksheet_SelectionChange(ByVal Target As Range)
        Dim Rng As Range
        Set Rng = Intersect(Target, Me.Selection)
            If Rng.Columns.Count = 1 Then
                ' Enable Ribbon Button
            Else
                ' Do nothing
            End If
    End Sub

 

[manc]

This might help.... https://stackoverflow.com/questions/41166091/enable-disable-ribbon-controls-independently

Best regards
manc

 

[decadence]

Hi manc, Thanks but this doesn't help unfortunately as it doesn't show an example of selection Change Event.

 

[manc]

Apologies, i did say i didn't what i was talking about.

I thought however that with a bit of tweaking, one of the examples on there shows onAction Event - thought that might be the same.
One last go - try here http://www.rondebruin.nl/win/section2.htm

Good luck finding your answer.
Beam me up Scottie - i'm out.

Best regards
manc

 

[decadence]

Thanks for your help, however still no luck I'm afraid. I have been looking all over for what I need but to no avail, may have to give up for now and come back to it another time, I know I have the cake but just need the cherry on top so to speak, Anyway Thanks again. Can anyone else help?