I have 2 columns. Column B contains 15 of my option button (Not sure if this'll affect but I just inserted one button and dragged the cell down to get 15 so the name for each option button is different). Column C contains the text values I have (contains VLOOPUP formula to give Yes, No or Perfect).

I want to make the option buttons unclickable (and preferably grayed out) if the value in column C is "No"


All that help I read that makes an unclickable option buttons uses macro. I've never used macros before, so if your solution is via macros, I would appreciate if you would explain it too.

Thanks.