Make multiple fields required in form before save

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