Hide/Unhide Macro causing Group Boxes containing Option Buttons to overlap

[Jorge36]

Hi,

Fairly new to VBA/Macro usage. I'm developing a dynamic questionnaire with Option Buttons and Check Boxes where, depending on the responses to each question, the macro would hide/unhide rows making other followup questions available. My issue is, when hiding rows, the group boxes containing Option Buttons (which I've hidden along with the rows) end up overlapping other Option Buttons messing up the "Cell Link" of those buttons.

Question is, is there a way to "disable" the Group Box along with the rows and option buttons so that they don't interfere with option buttons linked/grouped in other group boxes?

Cheers,
Jorge

 

[tygrrboi]

Have you tried setting the option buttons to "Move but do not resize with cells"?

 

[Jorge36]

Yeah, all buttons and group boxes are set to "Move but do not resize with cells"...

 

[My Aswer Is This]

They need to be set to:
Don't Move or size with cells

 

[Jorge36]

They need to be set to:
Don't Move or size with cells

@My Aswer Is This, is that the Group Boxes? Option Buttons? or both?

 

[My Aswer Is This]

I believe all.

@My Aswer Is This, is that the Group Boxes? Option Buttons? or both?

 

[Jorge36]

I believe all.

Tried it and it doesn't solve for it. The only difference between those two options ("Don't move or size" Vs "Move but do not size") is the position where the group box ends up, but the group box is still there and functional even though the underlying cells are hidden and even when I make the group box invisible... :/