Disabling "Save before Exiting" Pop-up

[Kenji]

Everytime the user makes a change and exits Excel, a pop-up comes up to ask
if the user is sure about closing the application without saving. Is there
a way to disable this? Not just on my computer, but this sheet is run on
many computers. Thanks!

Kenji

 

[Bob Greenblatt]

Everytime the user makes a change and exits Excel, a pop-up comes up to ask
if the user is sure about closing the application without saving. Is there
a way to disable this? Not just on my computer, but this sheet is run on
many computers. Thanks!

Kenji

Yes there is, but what do you really want to do? If you simply want to
ignore all the changes the user might have made and close the document, then
you can add a workbook close event macro that contains the line:
thisworkbook.saved=true

Realize that this will ignore all changes if the user forgot to save the
document.