Try

Private Sub Worksheet_Change(ByVal Target As Range)
Dim Temp As Double
Temp = Range("A1") / Range("B1")
If Temp < 0.5 Then
ToggleButton1.Enabled = True
Else: ToggleButton1.Enabled = False
End If
End Sub


"Shoney" wrote:

Hello,

I have created a toggle button from the Control Toolbox. The function of
the button is to hide/unhide columns. What I would like to do is make the
button available based on a cell's value.

More specifically, what I would like to do is enable the button only if cell
A1 has a value that is less than half of the value in B1.

Please let me know if this is possible, and if it is, how I should do it.

Thanks for any help you can provide.