Is there a way to elliminate the "Save Before Quitting" Message?

K

kenji4861

I'm running many excel sheets on my website and everytime, it change
excel forms, I don't want it to ask if the user is sure if they want t
exit the form without saving.

Thanks in advance
 
D

David McRitchie

Do you want to save the save file or not save the file.
The best way to answer such questions is to do a newsgroup
search on the exact wording of your message.

You can save the file and then you won't get the message.
ActiveWorkbook.save
ActiveWorkbook.Saved = True

You can tell Excel that the file has been saved and not get the
message and not cause the file to be saved.
ActiveWorkbook.Saved = True


http://support.microsoft.com/default.aspx?scid=kb;EN-GB;q238488
XL2000: Prompted to Save Changes After Setting the Saved Property to True


--
 
P

Peo Sjoblom

David gave you some possible answers but if you don't tell what it is
you want or how David's answer didn't solve your problem, then we
are left with telepathy which indeed is a tough nut to crack..
 
Top