Make multiple fields required in form before save

Try:

Private Sub Workbook_BeforeSave(ByVal SaveAsUI As Boolean, Cancel As Boolean)
Dim c As Range, stErr As String
For Each c In Range("E3, M3, R3, W3, E6, V6, E7, V7, V8, E9")
    If c.Value = "" Then stErr = stErr & c.Address & ", "
Next c
If stErr <> "" Then
    stErr = Left(stErr, Len(stErr) - 2)
    MsgBox "The following cells require user input:" & vbCr & vbCr & stErr, vbCritical + vbOKOnly, "Excel Forum"
    Cancel = True
End If
End Sub

Interesting problem!!

To save the blank template:

In the visual basic editor, press Ctrl-G to view the immediates window.

In the immediates window, type:

Application.EnableEvents = False

then press enter.

Flick back to your workbook, and save it.
Go back to the VBE, and in the immediates window, enter:

Application.EnableEvents = True

Sorted

The method I described in post #4 should work.

Attach the file, I'll save it as a blank template and attach it back.

Try the attached.

All I have done is exactly as I posted - opened your workbook, pasted the code into the ThisWorkbook module, disabled events, then saved. Please let me know how it works!