ExcelBanter - how disable a button forms ..

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - how disable a button forms .. (https://www.excelbanter.com/excel-programming/336011-how-disable-button-forms.html)

milly

how disable a button forms ..

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!

Norman Jones

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!

All times are GMT +1. The time now is 07:14 PM.