Uncheck checkbox WITHOUT running code on Auto_Close

[gorlosky]

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.

 Sub Auto_Close()
Range("A1").Select
UserForm2("CheckBox1").Value = False
ActiveWorkbook.Close savechanges:=True
End Sub

Private Sub CheckBox1_Click()
Dim dRange1 As String
Dim i As Integer
i = 1
dRange1 = "D1:D1"
Color_CheckBox_Select dRange1, i
End Sub