Uncheck checkbox WITHOUT running code on Auto_Close

I must be missing something...Is there a way to uncheck a checkbox WITHOUT running the code assigned to it, so that when I Close, everything is reset to unchecked for when I Open again ? I have a macro set to colorize the font based on whether it is checked or not. On Open the font is default black, from there on any checking or unchecking goes green or red. If the checkbox was already False, everything is fine. If the checkbox was True, then a "click" happens and that in turn jumps to the CheckBox1_Click code which I don't want to happen on close.

Please Login or Register  to view this content.

Please Login or Register  to view this content.