psgoldberg
New Member
- Joined
- Jul 11, 2013
- Messages
- 38
- Office Version
- 365
- Platform
- Windows
I'll try to be clear, but the situation is a bit confounding....
I have dozens of checkboxes (regular) on a sheet. I want to hide certain rows and use a macro to do so. In Excel 2013/16, everything works perfectly; that is, the row is hidden and the checkbox objects are Move and size with cell and are also hidden. When unhidden, everything goes back to visible.
When I run this in Excel 2010, initially, everything works exactly the same. However, when I save the file (again) and reopen it, when the rows are next hidden, the checkboxes all move to the collapsed/visible row - they have "moved" and will not move back.
I have tried deleting and recreating the boxes solely in 2010 and the behavior is the same. I have run with and without protection. I have tried Move and size with cells. I am out of ideas....
Any thoughts or suggestions would be remarkably helpful.
I am also looking at using ActiveX controls to do the same thing but am confused with how to create one example group of boxes (option boxes actually) in a frame and copy it and make them independent. But that will have to be a separate thread unless the answer is trivial....
I have dozens of checkboxes (regular) on a sheet. I want to hide certain rows and use a macro to do so. In Excel 2013/16, everything works perfectly; that is, the row is hidden and the checkbox objects are Move and size with cell and are also hidden. When unhidden, everything goes back to visible.
When I run this in Excel 2010, initially, everything works exactly the same. However, when I save the file (again) and reopen it, when the rows are next hidden, the checkboxes all move to the collapsed/visible row - they have "moved" and will not move back.
I have tried deleting and recreating the boxes solely in 2010 and the behavior is the same. I have run with and without protection. I have tried Move and size with cells. I am out of ideas....
Any thoughts or suggestions would be remarkably helpful.
I am also looking at using ActiveX controls to do the same thing but am confused with how to create one example group of boxes (option boxes actually) in a frame and copy it and make them independent. But that will have to be a separate thread unless the answer is trivial....
Last edited: