Hi everyone,
does anyone know how to generate the message "Document not saved" in Excel VBA?
I have tried to add
"Cancel = True" in Workbook_BeforeSave
and some combinations with Application.OnTime.
Setting Cancel to True really stop teh saving, but it does not generate the message.
The error message can be generated manually when hitting save in the QAT and hitting Esc before save is finished. (the file has to contain some content to be able to have the save running for enough time to use another command).
Thank you,
Harald