Assuming for this example that the cell you want to monitor is A1, this
Worksheet Change event code should do what you want; it makes the
CommandButton (what you are using, right?) visible if and only if the value
in the cell is TRUE...
Private Sub Worksheet_Change(ByVal Target As Range)
If Target = Range("A1") Then CommandButton1.Visible = Target.Value = "True"
End Sub
This version makes the CommandButton visible is the cell contains **any**
entry...
Private Sub Worksheet_Change(ByVal Target As Range)
If Target = Range("A1") Then CommandButton1.Visible = Target.Value <> ""
End Sub
Rick
> Is there a way to hide and unhide buttons when a cell is true/false? I
> use
[quoted text clipped - 5 lines]
>
> Adam Bush
adambush4242@hotmail.com - 24 Jan 2008 20:12 GMT
Rick,
Great! Thanks for your help. I appreciate the speedy response.
Thanks
Adam Bush
> Assuming for this example that the cell you want to monitor is A1, this
> Worksheet Change event code should do what you want; it makes the
[quoted text clipped - 23 lines]
> >
> > Adam Bush