I use grouped checkboxes (formular controls) in Excel sheets for the
purpose of diagnosis. One sheet is uses as template and I copy the sheet
as I need a new diagnosis with a macro.
There is a known bug in Excel, that causes changes of size and position of objects, like
images or control elements. (I know all the properties functions for locking sizes,… – it will
not avoid the bug changing the sizes)
I can correct sizes of images easily after the sheet is copied also with a macro.
But: at groups of checkboxes I have no solution, because within the new sheet copy
the groups gets also new group names, which I can’t use with a macro later for repositioning.
I would be extremly grateful, if you could help me out.
Any idea to give the checkbox groups unique names, like you could to with images oder
an idea to find and identify the groups after copy from the template sheet would be great.
Thomas Karg is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.