Preventing file from being saved if field left blank

[Hank Moore]

Is there a way to do so? I would want the user to get an alert that "cell AA123 cannot be left blank".

 

[Deepak]

Loop here!

http://forum.chandoo.org/threads/prompt-to-enter-missing-values-before-worbook-save.26523


or

Private Sub Workbook_BeforeSave(ByVal SaveAsUI As Boolean, Cancel As Boolean)
    If Len([AA123]) = 0 Then
        Cancel = True
        MsgBox "cell AA123 cannot be left blank"
    End If
End Sub