Private Sub Workbook_BeforeClose(Cancel As Boolean)
On Error Resume Next
If ThisWorkbook.Saved =FALSE Then
IF VBYES = MsgBox("当前文档" & ThisWorkbook.Name & "已经修改。在关闭之前,您是否要保存数据?", vbQuestion + vbYesNoCancel, "保存提示'')then
thisworkbook.save
ThisWorkbook.Saved = True
End If
End Sub
Private Sub Workbook_BeforeClose(Cancel As Boolean)
On Error Resume Next
If ThisWorkbook.Saved =FALSE Then
IF VBYES = MsgBox("当前文档" & ThisWorkbook.Name & "已经修改。在关闭之前,您是否要保存数据?", vbQuestion + vbYesNoCancel, "保存提示'')=vbYes then
thisworkbook.save
ThisWorkbook.Saved = True
End If
End Sub
Private Sub Workbook_BeforeClose(Cancel As Boolean)
On Error Resume Next
If ThisWorkbook.Saved = False Then
If MsgBox("当前文档" & ThisWorkbook.Name & "已经修改。在关闭之前,您是否要保存数据?", vbQuestion + vbYesNoCancel, "保存提示") = 6 Then
ThisWorkbook.Save
ThisWorkbook.Saved = True
End If
End If
End Sub
zjdh 发表于 2015-6-29 09:12
你把 On Error Resume Next 注销掉再试试。
Private Sub Workbook_BeforeClose(Cancel As Boolean)
ThisWorkbook.Save
End Sub
此时系统跳出是否保存对话框,应该是该语句还没用起作用。否则不应该跳出对话框。对吗.
补充:
我是用自定义窗体的按钮来执行关闭命令的:
Private Sub CommandButton1_Click()
thisworkbook.Close
end sub