"Document not saved" RRS feed

  • Frage

  • 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,


    Donnerstag, 19. Mai 2011 08:32