excel 用vba写当h列等于N时，下两列不能为空，否则不能保存，关闭也会提示？

Private Sub Workbook_BeforeClose(Cancel As Boolean)
If [H1] = "N" Then
MsgBox "关闭前提示"
Cancel = True
Exit Sub
End If
End Sub
要复制到
thisworkbook

温馨提示：答案为网友推荐，仅供参考

当前网址：https://verywind.cn/ee/vrj3j2e77e727jjjxjx.html