Question:
How can I disable Click() event via space bar in certain buttons of the application? (That is, I want to keep E3 from interpreting the space bar being pressed as a Click() event).
Solution:
To do so, you must set each button’s TabStop and TakeFocusOnClick properties as FALSE.
The ToggleButton object does not have the TakeFocusOnClick property. In this case, the solution is to disable and re-enable the control in its own Click() event, which forces Windows to remove the focus from the object — without visually changing its on/off state (Value). For example:
Sub ToggleButton1_Click()
' ... after the last line of the script ...
Enabled = False
Enabled = True
End Sub
