Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Hiding and restoring controls
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? -- Thanks, Paul S |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Restoring | Excel Discussion (Misc queries) | |||
ActiveX Controls vs Form Controls | Excel Discussion (Misc queries) | |||
Event procedures for controls added with Controls.Add | Excel Programming | |||
Restoring Links | Excel Programming | |||
Hiding controls with rows | Excel Programming |