The first thing to verify is that the macro is running when it is supposed to. I would add a checkpoint in the macro code to verify this.

The second thing to check is that the macro is detecting the state of the checkboxes. This can also be done either by checkpoints or debug.print statements.

Then check to see if it is taking the correct action on checked boxes. Again, checkpoints and debug.print.

Bottom line is that it seems like you have looked at everything except the code, but the code is where you are going to find the problem.

I would be happy to take a look if you attach your file (see yellow banner at the top of the page).