Hello all,

I am having a problem with this code. Could anyone please advise on what to do next? I want a message to pop up if the number in M3 is less than -100 or greater than or equal 100. Thank you. 

Private Sub Workbook_BeforeClose(Cancel As Boolean)
Dim Wsht As Worksheet
    For Each Wsht In Worksheets
    If Wsht.Range("M3").Value <= -100 >= 100 Then
    Application.Goto Wsht.Range("M3")
    MsgBox "Please check your work and correct!!"
Cancel = True
    End If
Next Wsht
End Sub
I can't seem to get this to work.

Thank you,


John