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

How far have you gotten, Rick? Do you have code that runs when
you select one of the radio buttons, but it doesn't do what you wanted?
Do you have code that reacts to the radio buttons but you're not sure
how to write the part that changes the protection? Or do you have
code to change protection but aren't sure how to make it respond to
the radio buttons?

--- "Rick" wrote:
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?