Disable Macros If Certain Cell is Not Blank

[madhuchelliah]

Hello Guys. I want to disable macro if cell C10 in sheet1 is not blank. It should be active if C10 in sheet1 is blank. I am running macros from ribbon. The macro name i want to disable is "Sub Start(control As IRibbonControl)". It should be applicable to the whole workbook. Thank you.

 

[steve the fish]

This doesnt disable it as such but exits if the criteria isnt met. Use one of these:

If Sheets("Sheet1").Range("C10") = "" Then Exit Sub

if the sheet is called Sheet1, or this if the code name of the sheet is Sheet1:

If Sheet1.Range("C10") = "" Then Exit Sub

 

[madhuchelliah]

Thank you Steve. Working cool !!!