Conditionally disabling activex toggle buttons

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!
 
J

JLGWhiz

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

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Programming a toggle button 2
disable multiple toggle buttons 1
locking and unlocking a textbox using command buttons 1
formatting a variable with vba 1
Accessing the text of a form command button from underlying macro 6
Initialize and script ActiveX controls not marked as safe 1
Toggle for Macro 5
toggle button nightmare 3

Top