jeffreybrown
Well-known Member
- Joined
- Jul 28, 2004
- Messages
- 5,152
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?
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