Deactivate option button and cell

Hi friends,

What I need to do is,
- If fruits is selected in question 1,
then automatically OptionButton3, OptionButton4 & OptionButton5 should get activated
and OptionButton6, OptionButton7 and cell E9 should get deactivated (means user should be restricted to use them).
- if vegetables is selected in qusetion1 ,
then automatically OptionButton6, OptionButton7 and cell E9 should get activated
and OptionButton3, OptionButton4 & OptionButton5 should get deactivated

I have used activeX option buttons as that is the requirement from my boss.
I tried to use If-Then-Else but its not working .

Sample file
Option button deactivation.xlsm

Hi,

In the workbook module, I used this code:

Please Login or Register  to view this content.

In the worksheet module, I used this code:

Please Login or Register  to view this content.

Hope this helps

Thanks ajryan88. you helped me to solve my problem

No problems.

Please don't forget to click on the * next to my post to say thanks