Hey everybody,
I have a file with multiple CheckBoxes which hide rows when they're marked off and sometimes there are also two ActiveX Option Buttons which should be hidden with the rows. I use this
ActiveSheet.OLEObjects("OptionButton12").Visible = False
to hide them, but when I unhide these rows, the Option Buttons have 0 height and change their position a little bit.
For me the best would be to fix the Option Buttons on a row no. 87 and 88 for example, because couple previous rows can be hidden too, so the buttons change their position according to the top of the document, so to choose "Don't move or size with cells" doesn't work for me.
I need the buttons to stay on the same row all the time independently on how far it is from the top of the document.
Does anybody know how to solve this problem? I use Excel 2010
Thanks, Petr