View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
JLGWhiz[_2_] JLGWhiz[_2_] is offline
external usenet poster
 
Posts: 1,565
Default Conditionally disabling activex toggle buttons

If it is from the control toolbox and on a worksheet, then:

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




"The Researcher" <The wrote in message
...
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!