if .Cells(i, j).Value = "" Then MsgBox "第 " & i & " 行,第 " & j & " 列内容未填写,不能保存!": GoTo 20
工作薄事件中这段代码改成:
If Cells(i, j) = "" Then
Cells(i, j).Interior.ColorIndex = 3
MsgBox "第" & i & "行" & "," & "第" & j & "列内容未填写,不能保存!"
GoTo 20
Else
Cells(i, j).Interior.ColorIndex = Cells(1, j).Interior.ColorIndex
End If