Why "do you want to save" messagebox prompted?

[darry]

All,

I have a question about preventing "Do you want to save" message box to prompt. Well, most cases are covered by workbook.saved property, however not the one when the user wants to switch off or restart pc when the file is open.

Do you know any simple way of delaing with that?

Thanks in advance.

You can test the issue with a rather simple code (to be included ThisWorkbook module).

Please Login or Register  to view this content.

[AliGW]

I have closed the many duplicates of this thread. Please post only one post per issue.

[darry]

applogies for duplicates and mess on forum.

[darry]

OK, I solved the problem.
For some reason when the PC is restarted the "beforeclose" event is not triggered. The solution is simple: to set ThisWorkbook.Saved to true and keeping it on all events like worksheet_change, worksheet_selectionchange and any other activities changing the file.