Radio buttons stop working when moved across worksheet

[K_A_Excel]

I'm having a strange problem.

I have 3 worksheets that have 2 sets of radio buttons at the bottom of each sheet. On the first sheet, these radio buttons work fine. On the 2nd and 3rd sheet, the radio buttons on the bottom-middle of the page work, but the ones on the bottom-left side of the page do not. When I hover over them the cursor changes appropriately, but when I click on them they just flicker and the button does not fill in.

When I tried remaking the buttons, I found that if the buttons are situated in the middle or right side of the sheet, they work fine, but if I move them over to the left side of the sheet they stop working. It does not seem to be any particular cell line that breaks them (it appears that they consistently stop working in the middle of the M column). When I move them back to the right side of the page, they work again. If I have one button from a particular GroupName filled and move it over to the left, it remains filled and if I click on different button from the GroupName that is situated on the right, the button on the right fills in properly and the button on the left clears properly...I just can't click the button on the left to refill it.

I've tried copying the radio buttons directly from the first sheet (whose buttons are working properly), but that didn't work. I have also copied the formats from the first sheet onto the second sheet, thinking maybe the format of the cells was breaking the radio buttons in some way, but that didn't work either.

Has anyone heard of anything like this happening?

 

[K_A_Excel]

I just tried putting in a different ActiveX Control (a text box) and it too stops working when it is moved to the left side of the page. I also tried Form Control's radio button and it seems to work fine. So I guess it's not a problem with the buttons themselves, but with ActiveX or how ActiveX interacts with the page?

 

[K_A_Excel]

I am also finding that when I first open the document, the buttons work fine for a few seconds (I can click between them 2-4 times) but then they stop working again. Is there some part of excel that loads up a bit slowly that could be interfering?

 

[lclingman]

Did you ever find a solution for this? I am having a similar problem.

 

[K_A_Excel]

Did you ever find a solution for this? I am having a similar problem.

I didn't I'm afraid. I just had to rearrange the pages so the buttons would never be in a non-working spot. Please let me know if you find a solution!

 

[lclingman]

I found a solution to my problems. It was some Windows/Excel quirk. As long as I was in "Page Layout" view they wouldn't work. Once I switched to "Normal" view they worked fine. I have no idea why, I'm just thankful they did.

 

[K_A_Excel]

Once I switched to "Normal" view they worked fine. I have no idea why, I'm just thankful they did.

That worked for me too! Awesome work, Iclingman!