Hello,
I can't seem to find the cause of this problem in my searches - hopefully someone has encountered this issue and knows a solution.
I have several Option Buttons from the Forms tool bar. I have these in Groups - two options buttons "Yes" and "No", placed in a Group Box. Before I place the option buttons in a group box, I have assigned a Cell Link. After assigning the cell link, I group the two option buttons and the Group Box together so they move a one group. I have assigned a macro to the group. All the macro does regarding the group is make it visible or hidden, if the respective row is hidden (I hide and unhide the rows in code and then hide the corresponding group box). After I hide the group box, I do use the code to set the cell link reference to zero to reset/clear the option buttons to nothing.
After I click the buttons and it is hiding and unhiding the rows and group boxes, it seems to be working fine, but a some point (I can't identify the trigger), when some of the groups are unhidden, they are not cleared out, and I find that the cause is that the cell link for the option button in question is blank, that is has lost the cell link reference.
I hope all that makes sense. Any ideas why the option boxes may lose the cell link?
Thanks for any help.
I can't seem to find the cause of this problem in my searches - hopefully someone has encountered this issue and knows a solution.
I have several Option Buttons from the Forms tool bar. I have these in Groups - two options buttons "Yes" and "No", placed in a Group Box. Before I place the option buttons in a group box, I have assigned a Cell Link. After assigning the cell link, I group the two option buttons and the Group Box together so they move a one group. I have assigned a macro to the group. All the macro does regarding the group is make it visible or hidden, if the respective row is hidden (I hide and unhide the rows in code and then hide the corresponding group box). After I hide the group box, I do use the code to set the cell link reference to zero to reset/clear the option buttons to nothing.
After I click the buttons and it is hiding and unhiding the rows and group boxes, it seems to be working fine, but a some point (I can't identify the trigger), when some of the groups are unhidden, they are not cleared out, and I find that the cause is that the cell link for the option button in question is blank, that is has lost the cell link reference.
I hope all that makes sense. Any ideas why the option boxes may lose the cell link?
Thanks for any help.
