View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Norman Jones Norman Jones is offline
external usenet poster
 
Posts: 5,302
Default 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!