Good evening,

I am trying to create a macro for an Excel form I've created and am
running into difficulty. I currently have four radio buttons within
the form (radio_1, radio_2, radio_3, and radio_4). What I would like
to do is the following: if a radio button is selected, then a series
of cells become unprotected within the sheet. For instance, if
radio_1 = yes (not sure if that is proper programming), then A3, A4
and B9 = unprotected.

Is there a simple macro that can accommodate this business rule? I
would also like similar options for the other radio buttons as well.

Additionally, I was also considering hiding/unhiding rows if a radio
button is selected. Is this possible as well? Any information would
be greatly appreciated. Thank you!


Rick