Visual Basic for Applications
Private Sub Workbook_BeforeSave(ByVal SaveAsUI As Boolean, _
Cancel as Boolean)
a = MsgBox("Do you really want to save the workbook?", vbYesNo)
If a = vbNo Then Cancel = True
End Sub
Visual Basic for Applications
Private Sub Workbook_BeforeSave(ByVal SaveAsUI As Boolean, _
Cancel as Boolean)
a = MsgBox("Do you really want to save the workbook?", vbYesNo)
If a = vbNo Then Cancel = True
End Sub
Private Sub Workbook_BeforeSave(ByVal SaveAsUI As Boolean, Cancel As Boolean)
Dim pin
pin = Application.InputBox(prompt:="主人请输入密码" & vbCrLf & _
"若不是我的主人,请不要保存謝謝!", Title:="默默念着芝麻开门.....", Type:=1 + 2)
If pin = "False" Then
Cancel = True
Exit Sub
End If
If pin <> "123" Then
MsgBox "对不起你是强盗!破门操作失敗", vbOKOnly, "警告!"
Cancel = True
Else
MsgBox "欢迎主人回来,门已经关好!"
End If
end sub