I am usisng the following code...and it works to a certain extent.
The Commandbutton1, which is normally HIDDEN does become visible if the data
at H2 is greater that 1111
In other words if I type in 1111 at H2 the commandbutton1 will be visible
BUT
if I have a formula in H2 that displays a number great than 1111, the
commandbutton1 does NOT appear.
Can this be fixed.
Thanks
If Target.Address = "$H$2" Then
If Target.Value 1111 Then
CommandButton1.Visible = True

END IF
End If

--
Norton Professional 2004 says this email is clean...believe it