how disable a button forms ..
Hi Milly,
Set the visiibility of the button to the same condition that triggers the
conditinal formatting.
For example:
Me.CommandButton1.Visible = _
Sheets("Sheet1").Range("A1").Value 10
----
Regards,
Norman
"milly" wrote in message
...
Hi all!
I have to disable a button forms when a condition is verified..
ex: a cell change font-color by conditional formatting and in the same
time
I have to disable a button...
any idea?
thanks!
|