title: Excel: make a field required before saving, but let me save the blank form
body: <p>Simply put, I want to make an Excel form that requires the user to fill in 5 cells, if even one isnt filled in then they cannot save the file. The issue is that with my current implementation I cant even save the blank document to be distributed to my coworkers. Is there a way to save once here and THEN have my VBA script work? below I have the code I've made for the form:</p>
  
  <pre><code>Private Sub Workbook_BeforeSave(ByVal SaveAsUI As Boolean, Cancel As Boolean)
    Dim whatCell As String
    whatCell = "B3"
    If Sheets("Report").Range(whatCell).Value = "" Then
       MsgBox "Pls enter value in Submitter"
       Cancel = True 'cancels the save event
       Exit Sub
     End If
  
    whatCell = "B4"
    If Sheets("Sheet1").Range(whatCell).Value = "" Then
       MsgBox "Pls enter value in Time/Date"
       Cancel = True 'cancels the save event
       Exit Sub
     End If
  
    whatCell = "B5"
    If Sheets("Sheet1").Range(whatCell).Value = "" Then
       MsgBox "Pls enter value in Customer Info"
       Cancel = True 'cancels the save event
       Exit Sub
     End If
  
    whatCell = "B6"
    If Sheets("Sheet1").Range(whatCell).Value = "" Then
       MsgBox "Pls enter value in Issue Description"
       Cancel = True 'cancels the save event
       Exit Sub
     End If
  
    whatCell = "B7"
    If Sheets("Sheet1").Range(whatCell).Value = "" Then
       MsgBox "Pls enter value in Repeatable"
       Cancel = True 'cancels the save event
       Exit Sub
     End If
  End Sub
  
  Private Sub Workbook_Open()
  
  End Sub
  </code></pre>