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

  • Thread starter Thread starter kenji4861
  • Start date Start date
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
 
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


--
 
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..
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel 2007 exits without asking if I want to save 2
How to ensure workbook is saved before exiting Excel? 6
Excel Providing user message when RED X clicked & properly closing application. 2
saving excel file 9
Set Cells to A1 Before Save 2
Is there a comparison list of commands? (Excel 2003 vs 2007) 2
Message Box on exiting workbook 1
Document Not Saved message 4

Back
Top