Message Box Prompt

[Guest]

I have a code running behind a button which, once pressed, saves the workbook
in a specified directory. Now, I want to give the users the option to cancel
the action.

Therefore, I want a message box that tells the users that if they click on
"OK", the file will be saved in a particular directory, but if they don't
want the file getting saved, they should press "CANCEL".

I want to create a message box which does the following:

If user clicks "OK", the workbook closes.

If user clicks "Cancel", the workbook remains open.

How can I code this?

Thanks, in advance, for your help.

-Yasser

 

[Bob Phillips]

If MsgBox("OK To Save",vbOKCancel) = vbOK Then
Activeworkbook.Close
End If

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)