Undo VBA code repeats only on table header for some reason. Can't figure out why.

So I have a sheet that I am attempting to lock down certain cells with VBA. (I can't use the protect feature for this for a few reasons). The code I have appears to work just fine everywhere except for on a table header. It appears to repeat itself once essentially redoing the action it just undid and bringing the error message back up. Any ideas what I could do to fix this? Below is the code.

Please Login or Register  to view this content.

Okay so I think I know why it is doing it. When I delete the header the table automatically fills in the "Column #" in place of it since it can't be blank. It is recognizing this as an action and undoing it. Any way I can prevent this from happening?

No suggestions on how I could fix this bug? Still open to any ideas here.