Toggle "Select Objects" Arrow

[jbrouse]

Greetings,

Is there any way to toggle the Select Objects arrow off when a togglebutton is clicked. My Worksheet_BeforeRightClick() function only works when the Select Objects arrow is toggled Off (so that I can Right-Click in a cell). I would like to toggle the Select Object arrow to Off when my togglebutton, "Edit", is clicked.

Is this possible?

Thanks in advance!

 

[jbrouse]

I can use CommandBars("Drawing").Controls("Select Objects").Execute to toggle the button on or off, but now I need to modify the IF statement below so that it will only Execute if the button is already toggled as ON. Can anyone please assist me in replacing the .??? with code that works? There is no Object.Value for CommandBar controls, so I can't just put .Value = True.

Private Sub Edit_Click()

    If Edit.Value = True Then
        If CommandBars("Drawing").Controls("Select Objects").???
             CommandBars("Drawing").Controls("Select Objects").Execute
        End If
    End If

End Sub

 

[jbrouse]

Private Sub Edit_Click()

If Edit.Value = True Then
If CommandBars("Drawing").Controls("Select Objects").State = msoButtonDown

CommandBars("Drawing").Controls("Select Objects").Execute
End If
End If

End Sub

For anyone who is interested, I achieved my goal, using the above code. Sometimes attempting to explain it helps you solve your problem!