BeforeSave Function
BeforeSave Function
(OP)
I'm using the BeforeSave function and usng the code that is in the Microsoft Excel VB help section under BeforeSave. When you click save, a box is supposed to pop up asking if you really want to save. If you click "no" then it isn't supposed to save. Only when I click no it saves anyway. Any ideas? Thanks





RE: BeforeSave Function
Private Sub Workbook_BeforeSave(ByVal SaveAsUI As Boolean, Cancel As Boolean)
Dim a As Variant
a = MsgBox("Do you really want to save the workbook?", vbYesNo)
If a = vbNo Then Cancel = True
End Sub
Not sure why yours would not work properly.
DimensionalSolutions@Core.com
While I welcome e-mail messages, please post all thread activity in these forums for the benefit of all members.
RE: BeforeSave Function
RE: BeforeSave Function
DimensionalSolutions@Core.com
While I welcome e-mail messages, please post all thread activity in these forums for the benefit of all members.