Message Box on Workbook Close

[adam2308]

I'm after a piece of code that gives the user a message box on closing the workbook.

The message should say "Have changed the update time?"

If Yes: close workbook
If No: End Macro without closing workbook


Thanks,
Adam.

[SOS]

Hi Adam,

If Yes is chosen do you want to close the workbook and save changes?
And if No is chosen you just want to go back to the workbook so the user can continue working?

Is that correct

[adam2308]

If yes - then ask the user to save changes or not in the usual way
If no - just want to go back to the workbook so the user can continue working

[SOS]

Adam,

Then I don't think it should be a Workbook Close event because no matter what button is chosen the workbook will close anyway. Still not sure though what type of event it should be. Will continue to think about it

[snb]

What do you want to accomplish, or what do you want to prevent ?