Control Button disappear when criteria met

I have a sheet with names, months and if "Met?" (criteria). Next to each entry row, active control buttons are available for user to click to erase Name and Month if met. (The "Met" column has formulas build in but is not relevant to this inquiry).

I am looking for a code to make the Control button only visible if criteria met (If "Yes" indicated) and disappear if criteria not met. Also if made visible, button on each row should erase data in columns A & B of subsequent row. I began below code but it only addresses first part of my request and also does not work !!

Please Login or Register  to view this content.

Moderator's note: Please take the time to review our rules. There aren't many, and they are all important. Rule #2 requires code tags. I have added them for you this time because you are a new member. --6StringJazzer


Thanks kindly to anyone offering solution:

I've used a UDF (user defined function) rather than worksheet_change event

each row gets a formula with the name of the button on that row.

=udfSHOWBUTTON(UPPER(C2)="YES","Button 1")

assign this macro to all buttons

Please Login or Register  to view this content.

1. Not required. Can be deleted.
2, Formula is in column D. To get name of button check Name Box, to left of formula bar, when selected. Or use Selection pane (ALT+F10)