用VBA可以实现:Private Sub Workbook_BeforeSave(ByVal SaveAsUI As Boolean, Cancel As Boolean)With Sheet1
lstrow = .Range("a65536").End(3).Row
For r = 1 To lstrow
If .Cells(r, 1)"" And .Cells(r, 3) = "" Then m = m + 1
Next
If m > 0 Then
Cancel = True
MsgBox "工作表sheet1的数据填写不全"
E...