I have a workbook with a BeforeSave macro. It works fine if you run another macro before the first time you try to save and works fine if i press the save button a thousand times (i assume, haven't actually pressed it that many times), but if i press the save button and then run another macro, when i press save again the macro doesn't run.

Does anybody know why???

Thanks

Private Sub Workbook_Beforesave(ByVal SaveAsUI As Boolean, Cancel As Boolean)

If Cells(1, 4) = "" Then
    MsgBox "Sheet must be validated first"
    Cancel = True
ElseIf Cells(1, 4) = "Validated" Then
End If
    
End Sub