| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Conditionally disabling activex toggle buttons
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! |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Toggle Cell Colour Conditionally | Excel Worksheet Functions | |||
| Conditionally Disabling Optionbuttons | Excel Programming | |||
| ActiveX Toggle Workbook | Excel Worksheet Functions | |||
| have toggle buttons but everytime print preview buttons move | Excel Discussion (Misc queries) | |||
| Conditionally disabling formulas | Excel Programming | |||
Linear Mode
