Hiding option button (radio button) when hiding row

**ker9** · 01-13-2012, 05:48 PM

It's weird but true - I have two yes/no option buttons in two different rows (4 buttons total). While I'm working in the document I can hide and unhide the row and the buttons hide and unhide perfectly. I have placement set to 1 (move and size with cells). When I save and exit the file and then open it up again, all the radio buttons have been shrunk down to 0 height and are impossible to see/find. I have to reset the size programmatically to find them and when I see them again they are in a higher location than when saved.

I made sure the rows were tall enough to fully contain the button.

There is nothing in the on Open or on Close events (no workbook events).

Any suggestions for keeping these buttons in the correct place when hiding rows? (They are active x buttons not form controls.)

Thanks!

**Winon** · 01-13-2012, 06:09 PM

Have you tried to lock the Aspect Ratio in The Format Control?

**ker9** · 01-13-2012, 06:16 PM

Thank you for your response. I just tried it - the buttons stay where they were - which is not in the correct place when a row above them is hidden. They are not moving with the row they are in.

**Winon** · 01-13-2012, 06:28 PM

In the Properties window then change the Placement Value from 2 to 1. Also important is to resize the Radio Button to just inside the borders of the row you wish to hide. Try it! It works for me!

**ker9** · 01-13-2012, 06:46 PM

Thank you - I have doubled checked all the settings and they are placement 1, aspect ratio locked and clearly inside the row. As I said everything works great while I'm in the document, the problem arises when I save and close the file and then reopen it - at that point the buttons are all messed up again.

Edit: The rows are hidden before I close the file and stay hidden until another button unhides them. The are not linked to a cell - it resets the Top on all of them to what appears to be the very top of the first hidden row (rows 9 & 10).

**Winon** · 01-13-2012, 07:05 PM

Hello ker9,

See attached WorkBook. No problem. Do you perhaps have some VBA code in yours? If Yes, Something in there is messing you around!

**ker9** · 01-13-2012, 07:12 PM

There is a quite a bit of code in the document, almost all relating to checkboxes in rows further down. There is no workbook event code (nothing on open/close). Nothing anywhere that would force option buttons to change location/size. I'm going to have to give up for the night and try again fresh tomorrow. Thank you for your help.

**Winon** · 01-13-2012, 07:19 PM

Check if your VBA code contains any "Columns.Autofit", or resizing of Rows. It is a wild geuss, but we will hopefully get there eventually.

'Till later then!