Reset checkbox on Ribbon back to unchecked

jeffreybrown

Well-known Member
Joined
Jul 28, 2004
Messages
5,145
I have a checkbox id in the RibbonX which when the user presses will run a macro; however, certain sheets do not require this macro.

When the user checks the checkbox they recieve a Msgbox telling them this will not run on the activesheet if it should be excluded.

How can the checkbox be reset back to non-checked before Exit Sub?

Code:
Sub ManageFormat(control As IRibbonControl, pressed As Boolean)
    Dim ws As Worksheet
    Set ws = ActiveSheet
    If ws.Name = "Sheet1" Then MsgBox "Wrong Sheet"
    Exit Sub
        
    If pressed Then
        'Do Something
    Else
        'Do Something Else
    End If
End Sub
 

Some videos you may like

Excel Facts

How can you automate Excel?
Press Alt+F11 from Windows Excel to open the Visual Basic for Applications (VBA) editor.

Watch MrExcel Video

Forum statistics

Threads
1,109,523
Messages
5,529,334
Members
409,863
Latest member
stacy09
Top