Save changes prompt when I am shutting down the computer.

[ginozza]

Hello everyone,

I ve tried:
Private Sub Workbook_BeforeClose(cancel As Boolean)

Application.EnableEvents = False
ThisWorkbook.Save
Application.DisplayAlerts = False
Application.Quit

End Sub


It works fine when pressing X to the program but shutting down the computer give me the "save question".

I am using Office 2010.

Is there any other code I can try in Workbook_BeforeClose or even catch the" windows shutting down" somehow to run a sub?

thanks in advance

[TMS]

Perhaps try it in this order:

Please Login or Register  to view this content.

I don't know if that will fix it but I'm working on the basis that the last thing you want to do before closing is to save the workbook. Putting the DisplayAlerts before the save shouldn't hurt and it means there's no activity between the save and the quit.

Regards, TMS

[ginozza]

Hello,

thanks for your responce. I ve tried your code but unfotunately the message comes. I believe that the windows shutdown is stopping/pausing the VBA causing the " Private Sub Workbook_BeforeClose(cancel As Boolean) " not to run.
I was thinking, maybe it is possible to use the wm_queryendsession to prevent windows shutdown, save and exit workbook and then shutdown(or restart) the computer. My problem I m quite new to VBA programming and do not know how to do that.
Can someone help me with that? or anyone any other idea?

Thanks again

[ginozza]

Hello,

I found time to experiment a bit on this issue today and found out that if I make a Doevents after Application.Quit it works...But not in all files!
In one file where the code is relative small it works (this is actually my test code where I am doing the experiments to find a solution to the problem).
On the file where the code is much longer it doesn't work- I assume when the code is long, the reaction time of excel is slower...

still looking for an answer...