dwg83
Board Regular
- Joined
- Nov 8, 2006
- Messages
- 174
This is a good one!
I have a series of 10 check boxes (activeX) in each column (A:J). For each column I have an additional check box (off to the side, where they won't be hidden) that determines if that column is hidden or showing AND it makes the check boxes in that column not visible or visible depending if the column is hidden. You can play around, hiding and unhiding columns and the checkboxes stay in their respected columns upon unhiding. Now....hide columns B:H using your check box commands, save, and close excel. Open the file back up, unhide the columns, and now all of a sudden the check boxes don't stay in their respective columns! Help me solve this puzzle!!!
Thanks!
David
I have a series of 10 check boxes (activeX) in each column (A:J). For each column I have an additional check box (off to the side, where they won't be hidden) that determines if that column is hidden or showing AND it makes the check boxes in that column not visible or visible depending if the column is hidden. You can play around, hiding and unhiding columns and the checkboxes stay in their respected columns upon unhiding. Now....hide columns B:H using your check box commands, save, and close excel. Open the file back up, unhide the columns, and now all of a sudden the check boxes don't stay in their respective columns! Help me solve this puzzle!!!
Thanks!
David