Hi all,

I have a worksheet that contains 25 rows for data entry. Each row has 2 data entry cells and five Form Control check boxes (total of 125 check boxes). The user enters a number between 1 and 25 in a cell to state how many rows they need and a VBA macro hides the other rows. This makes the workbook easier to use and less cluttered. The user can change the number at any time and the macro will hide or unhide the right number of rows and everything looks good. But when the user saves the workbook, let's say with 6 visible rows (19 hidden), closes it and then reopens it, the hidden check boxes have lost their positions. When the user tries to enter a number higher than when he closed the workbook, the check boxes are all stacked on top of one another. It seems Excel 2010 does not save the relative check box positions. I found a description of the bug here: http://www.excel-ticker.com/position...-in-excel-2010

The only workaround I found was to unhide all rows before save and hide them again when the user reopens the workbook. This is far from ideal and it won't be easy to maintain as the spreadsheet grows and more objects need to be hidden.

Does anyone know how I can fix this? I am using Excel 2010 SP2 which is supposed to contain a fix for this but it doesn't.

Thanks in advance!