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! |
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! |
All times are GMT +1. The time now is 06:21 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com