Preventing the "Do you want to save the changes you made..." from popping up.

[jonvanwyk]

The ribbon is removed in my form, so users cannot save the form unless they hit "Ctrl S" or choose "Yes" when closing the document and are promoted with "Do you want to save the changes you made?" I would like to remove the prompt asking them if they want to save the document. The base form should always be blank when the next person opens it.

Also, perhaps my approach above is the wrong for what I am wanting to do. Is there instead code that can be put into my code below to simply erase any information entered into the form since the last save? This way, if the user chooses "Yes" to save the changes, the information they entered gets erased anyway?

Please Login or Register  to view this content.

[Leith Ross]

Hello jonvanwyk,

Set the Saved property to True before the workbook is closed.

Please Login or Register  to view this content.

[jonvanwyk]

worked like a charm. thank you.