P
Paul S
I have a spreadsheet that contains controls such as checkboxes, combo boxes,
etc. When a user marks a checkbox, several rows are hidden, and the controls
that are contained on those rows have their Visible property set to False. I
have them formatted to move with the rows.
A problem happens when I go to save the spreadsheet with some of these
hidden and invisible. When I reopen the saved spreadsheet, and "unhide" the
selections, the data on the rows is correct, but the positioning of any
controls is not correct. My assumption is that the positions are not being
save if they are invisible and the rows hidden.
Is there a way to make sure the positions are kept "as designed" so they
restore correctly even when the controls and rows are hidden when the
spreadsheet is saved?
etc. When a user marks a checkbox, several rows are hidden, and the controls
that are contained on those rows have their Visible property set to False. I
have them formatted to move with the rows.
A problem happens when I go to save the spreadsheet with some of these
hidden and invisible. When I reopen the saved spreadsheet, and "unhide" the
selections, the data on the rows is correct, but the positioning of any
controls is not correct. My assumption is that the positions are not being
save if they are invisible and the rows hidden.
Is there a way to make sure the positions are kept "as designed" so they
restore correctly even when the controls and rows are hidden when the
spreadsheet is saved?