Conditionally disabling activex toggle buttons

  • Thread starter Thread starter The Researcher
  • Start date Start date
T

The Researcher

Does anyone know how I can disable an activex toggle button (I am imagining
it going lightgrey or something like that and the use not being able to use
it) depending on the value of a specific cell?

Any help is greatly appreciated!
 
If it is from the control toolbox and on a worksheet, then:

Sub dk()
Sheets(1).ToggleButton1.Enabled = False
End Sub
 
Back
Top