ThisWorkbook.Close (SaveChanges = True) ' will avoid the dialog box and thus
help prevent problems.

Best wishes,

Jim

"JohnUK" wrote:

Hi,
Because my workbook does a lot of work before closing down, if someone was
to press Cancel on the Save dialogue box it really messes things up.
Is there a way in which maybe the Cancel can not be shown and be left with
the Yes and No instead?
Regards
John