Check boxes, affected by multiple sheets

[Afro_Cookie]

I have 2 sheets, first is a basic table that will help establish priority of work, that is where the check boxes come in. On the second sheet, when the work is completed, a date is put into B:B.

I want to change the value of the reference cell from TRUE to FALSE based on the value on sheet 2. This is what I've tried so far and it works, but when the check box is used manually on sheet 1, it overwrites the code in the check box reference cell.
=IF(B2="",TRUE,FALSE)

Any ideas would be helpful.

 

[COwen]

I just put a clear rectangle over the check box and assigned the following macro to it.

Sub DoNothing()
If Sheet1.Range("B2").Value = "" Then
Sheet1.Range("B2").Value = " "
ElseIf Sheet1.Range("B2").Value <> "" Then
Sheet1.Range("B2").ClearContents
End If
End Sub