title: Excel VBA - Make fields required but save blank fields
body: <p>I have added the following code to make fields required before saving them.</p>
  
  <pre><code>Private Sub Workbook_BeforeSave(ByVal SaveAsUI As Boolean, Cancel As Boolean)
  If Cells(2, 2).Value = "" Then
  MsgBox "Please enter Date"
  Cancel = True
  End If
  End Sub
  </code></pre>
  
  <p>However, our requirement is that the fields should be blank when the excel file is openEd by the user. My problem is that the code does not allow me to save the file for the first time with blank fields.</p>
  
  <p>Can you please suggest a workaround? I'm not happy that MS Excel does not a required field option...</p>