automatic close of pages
 

hi all !!!
in presence of a "false" in my cell a1 i want my worksheet to save and close..
can u help me ??
ty , paolo

automatic close of pages
 

Copy this into your sheet of choice.

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
If Cells(1, 1).Value = False Or Cells(1, 1).Value = "FALSE" Then
ThisWorkbook.Save
Application.Quit
End If
End Sub

Hope this helps!
"N+" wrote:

hi all !!!
in presence of a "false" in my cell a1 i want my worksheet to save and close..
can u help me ??
ty , paolo