Checking if some cells are empty when file is being saved

  • Thread starter Thread starter Bob Ptacek
  • Start date Start date
B

Bob Ptacek

Is there something that can be checked if the "Save" function is executed.

I have a file with a number of worksheets and I don't want a user to be able
to save it without entering some data. Once the "save" is selected I would
like to check to see if all required fields are still empty so I can display
an error
 
hi
you could use the before save event to check certain cells for input.
but since you didn't give a lot of details, i can only give a overly simple
answer.
Private Sub Workbook_BeforeSave(ByVal SaveAsUI As Boolean, Cancel As Boolean)
Dim r As Range
Set r = Sheets("sheet1").Range("A2")
If r = "" Then
MsgBox "the require entry at " & r.Address & " need data!"
r.Select
Cancel = True
End If
End Sub

the above only check 1 cell and cancels save if no data in the cell.
you would need to reset r to the various cells that need input. not sure how
many you have.

regards
FSt1
 
Back
Top