Form Checkboxes are not maintaining cell link
I have a bunch of Form Checkboxes on a worksheet. Each one is linked to the
cell that they are sitting on. For example, the checkbox in cell B40 is cell
linked to B40. The problem is, if I hide rows that have these checkboxes,
the remaining checkboxes sometimes have an incorrect cell link.
Example: Here are the rows and corresponding checkboxes.
B39
B40
B41
B42
B43
B44
I hide row 39 and 40. Now the checkbox in B41 has cell link to B39. I need
the checkboxes to stay with their corresponding rows.
|