Multiple Checkbox Form Control

[wheath]

I put a number of checkboxes in my Excel spreadsheet. I linked a couple of them, but now want to copy and paste those with the formatting over a larger area, but it isn't working.

I am getting the formatting or linking not associating with the correct cell location.

For instance, if the checkbox I formatted is linked to B2, everything I paste is attached to B2 instead of adjusting as I move down the spreadsheet.