Hello. There was a thread in 2013 that discussed my issue, but it ended in an argument over rules. So I'll ask it here:

My worksheet change event macros stop working what seems to be randomly. If I close and reopen the workbook, they start working again. This does happen after a vba compiler error is triggered (I do have an on error control in the code). Please let me know what causes this or if you need more info. I can attach the code - which is only a few lines. Thanks!!