Forum Discussion
When inserting or deleting a row the form controls and ActiveX controls are moved.
Hi NikolinoDE
First of all, thanks for your efforts to help me.
But no, this is not what I'm trying... I don't want to delete anything. The problem is that now, when you add or delete a row that it is previous to the one that has the form control, the form control behaviour has changed. I'll try to explain myself a little bit more...
The problem is that in addition to moving down a row (desired behaviour when inserting a row above), the form control moves down one more row. In the example I put in the images, the checkbox and the linked cell were in row 4, when inserting a row above, they go down to row 5 (so far, correct, and is the behaviour it had before), but the checkbox, actually goes down to row 6 (which is only observed when you click on it or when you save and reopen the document), as seen in the 3rd image.
Please, can anyone figure out what might have changed to make it behave differently?
Thanks
In this case you want the ActiveX element to adjust the check box to the height of the picture and not to the line. At the same time, these should remain in the same line number.
Maybe it could be done with VBA code, but it is time consuming. Time that I cannot provide at the moment.
What I could also recommend you make the same settings ...
- Control element, right mouse button, "Format control element ..."
2Click on "Properties"
Object positioning
- Click on the selection point "Dependent on cell position and size". Press "OK".
... also with the pictures regardless of the check boxes, so pictures and check boxes will move at the same time.
Thank you for your patience and understanding