Private Sub Workbook_BeforeClose(Cancel As Boolean)
If Sheets(3).Range("A2").Value <> "" Then ThisWorkbook.Close savechanges:=False
End Sub
Private Sub Workbook_BeforeSave(ByVal SaveAsUI As Boolean, Cancel As Boolean)
If Sheets(3).Range("A2").Value <> "" Then Cancel = True
End Sub