Change the state of a custom CommandBar button
2000-02-05 Commandbars 0 167
The macro below shows how you can change the state of a custom CommandBar button so it displays as depressed or not.
Sub ToggleButtonState() Dim m As CommandBarControl Set m = CommandBars("CommandBarName").Controls(1) If m.State = msoButtonDown Then m.State = msoButtonUp Else m.State = msoButtonDown End If Set m = Nothing End Sub