ActiveX

To specify when buttons appear

Set the ButtonDrawMode property.

Note that you can combine values 1 (Current Cell), 2 (Current Column), 4 (Current Row), 8 (Always Button), and 16 (Always Combo) using the Or operator to limit where buttons are displayed in the control.